So is there no way to make oder by work with names?
-Original Message-
From: Heikki Linnakangas [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2008 3:00 AM
To: Blanco, Jose
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Oder by not working
Heikki Linnakangas wrote:
> Unlike
I was hoping that the a newer version of postgres ( 8.1.11 ) would solve
the problem we see when we use order by to get a listing of names. Let
me explain the problem.
Suppose we have the following 3 names in a table:
Ta, A
Ta, Z
Tab, A
I would expect them to show up in the oder shown above
I have the following table
Table "public.authorsort"
Column | Type | Modifiers
--+---+---
ordernum | integer |
handle | character varying(30) |
Indexes: author_handle_idx btree (handle)
As you can tell I have a
Recently, we ran an 'vacummdb --full' on our database, and I'm finding
that a scrip that use to take just a couple of ours to run, is now
taking 12 hours to run. It's a perl script that does a lot of inserting
into a few tables. I've tried dropping indices to speed up the inserts,
but this does n
