Steve Holdoway <[EMAIL PROTECTED]> writes:
> I managed to get this working properly by dropping the index on the
> url column, and making it the primary key instead. Can anyone point me
> at docs that define the difference between a primary key and an unique
> index on the same field? I'm a bit con
I managed to get this working properly by dropping the index on the url column,
and making it the primary key instead. Can anyone point me at docs that define
the difference between a primary key and an unique index on the same field? I'm
a bit confused here!
Cheers, Steve
On Wed, 16 May 2007
@postgresql.org
Subject: [ADMIN] improve select performance...
Can anyone out there help me, I'm having a bit of a problem trying to
improve the performance of a php script that does a data load?
At the moment, the script checks a database to see if the entry is present,
and, if not, it adds it
Can anyone out there help me, I'm having a bit of a problem trying to improve
the performance of a php script that does a data load?
At the moment, the script checks a database to see if the entry is present,
and, if not, it adds it. The table has about 400,000 rows, and I'm checking a
bulk loa
