On Feb 10, 2007, at 12:34 PM, Tom Lane wrote:
Arturo Perez <[EMAIL PROTECTED]> writes:
Saturday I changed a table to add a varchar(24) and a TEXT column.
You didn't actually say which of these tables you changed?
I'm not very good at reading these but it looks like sort memory
might
be t
On Feb 10, 2007, at 12:34 PM, Tom Lane wrote:
Arturo Perez <[EMAIL PROTECTED]> writes:
Saturday I changed a table to add a varchar(24) and a TEXT column.
You didn't actually say which of these tables you changed?
Sorry, I changed extended_user.
I'm not very good at reading these but it
Arturo Perez <[EMAIL PROTECTED]> writes:
> Saturday I changed a table to add a varchar(24) and a TEXT column.
You didn't actually say which of these tables you changed?
> I'm not very good at reading these but it looks like sort memory might
> be too low?
The runtime seems to be entirely in the
On Feb 9, 2007, at 11:43 AM, Merlin Moncure wrote:
On 2/8/07, Arturo Perez <[EMAIL PROTECTED]> wrote:
Hi all,
Saturday I changed a table to add a varchar(24) and a TEXT column.
It's used for some reporting purposes (small potatoe stuff really)
and the TEXT column remains mostly empty. Howeve
On 2/8/07, Arturo Perez <[EMAIL PROTECTED]> wrote:
Hi all,
Saturday I changed a table to add a varchar(24) and a TEXT column.
It's used for some reporting purposes (small potatoe stuff really)
and the TEXT column remains mostly empty. However, this week
performance has gotten terrible. Queries
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/08/07 20:50, Arturo Perez wrote:
> Hi all,
>
> Saturday I changed a table to add a varchar(24) and a TEXT column. It's
> used for some reporting purposes (small potatoe stuff really) and the
> TEXT column remains mostly empty. However, this we
Hi all,
Saturday I changed a table to add a varchar(24) and a TEXT column.
It's used for some reporting purposes (small potatoe stuff really)
and the TEXT column remains mostly empty. However, this week
performance has gotten terrible. Queries joining against the
aforementioned table h