Viewing page 2 of 3
« | Back | Next | »

How to index a database

PostgreSQL Posted on 15 Feb 2006, 04:17 AM Posted By Chris Smith  
Database indexing can be quite tricky. Here is a basic guide on how to get started with it, when you should index and when you shouldn't.


Written for Interspire
Read More

Showing Running Queries

PostgreSQL Posted on 15 Feb 2006, 01:11 AM Posted By Chris Smith  
Newer versions of PostgreSQL have a 'pg_stat_activity' view to show you who is currently connected to your database system.

By default, this doesn't show you the queries being run.

How do you show that?

Edit your postgresql.conf file and add (or uncomment):

stats_command_string = true

...
Read More

PostgreSQL Query Timing

PostgreSQL Posted on 15 Feb 2006, 01:06 AM Posted By Chris Smith  
How do you know how long a query took?

PostgreSQL lets you time the queries and print the output in your psql session.

Create a $HOME/.psqlrc file with:

\timing

in it and next time you log in to a psql session, PostgreSQL will show you how long the query took!

Doing it this way means ...
Read More

Deleting Data

PostgreSQL Posted on 12 Feb 2006, 06:24 AM Posted By Chris Smith  
Deleting old data from your database is a useful thing to do. If you keep a list of books or cd's you own and you sell or give something away, you can remove it from the list. Here's a quick introduction on how to do it.
Read More

Updating your data

PostgreSQL Posted on 12 Feb 2006, 05:41 AM Posted By Chris Smith  
Now we can add and show the records in a database, how can we update it? This tutorial will give you a quick introduction on how to do it.
Read More

Retrieving Data from your database

PostgreSQL Posted on 09 Feb 2006, 05:32 AM Posted By Chris Smith  
We've seen how to put data into our database, here's a look how to get it back out again using php and the postgresql functions.
Read More

Adding data to your database

PostgreSQL Posted on 07 Feb 2006, 05:47 AM Posted By Chris Smith  
Adding data to your database is an essential part of creating a dynamic site. Here's a look at how to get started.
Read More

Introduction to Database Datatypes

PostgreSQL Posted on 07 Feb 2006, 05:31 AM Posted By Chris Smith  
Databases can store lots of different data in quite a few different ways. This guide shows some of the basic and common types you'll run across and how to pick which type is the right one to use.

Written for Interspire
Read More

Introduction to Databases

PostgreSQL Posted on 07 Feb 2006, 05:29 AM Posted By Chris Smith  
Before we start coding anything, we'll look at how to design your database. It can be quite a complicated procedure but this guide should show you everything you need to think about.

Written for Interspire
Read More

PostgreSQL Databases

PostgreSQL Posted on 07 Feb 2006, 05:22 AM Posted By Chris Smith  
PostgreSQL of course supports multiple databases. Here's an introductory look at how to get them up and running.
Read More