On Tue, 2005-08-30 at 08:13 -0500, Frank Wiles wrote:
> On Tue, 30 Aug 2005 18:35:30 +0530
> "Akshay Mathur" <[EMAIL PROTECTED]> wrote:
>
> > Hello Friends,
> >
> > We were having a database in pgsql7.4.2 The database was responding
> > very slowly even after full vacuum analyze (select count(*)
On Sat, 27 Aug 2005 21:28:57 +0530 (IST)
<[EMAIL PROTECTED]> threw this fish to the penguins:
> Hello Friends,
> We were having a database in pgsql7.4. The database was responding very
> slowly even after full vacuum (select
> count(*) from some_table_having_18000_records was taking 18 Sec).
One
Hello Friends,
We were having a database in pgsql7.4. The database was responding very
slowly even after full vacuum (select
count(*) from some_table_having_18000_records was taking 18 Sec).
We took a backup of that db and restored it back. Now the same db on
same PC is responding fast (same query
On Aug 30, 2005, at 9:05 AM, Akshay Mathur wrote:We were having a database in pgsql7.4.2 The database was responding very slowly even after full vacuum analyze (select count(*) from some_table_having_18000_records was taking 18 Sec).On a 7.4.2 db, there should probably be no index bloat, but there
On Tue, 30 Aug 2005 18:35:30 +0530
"Akshay Mathur" <[EMAIL PROTECTED]> wrote:
> Hello Friends,
>
> We were having a database in pgsql7.4.2 The database was responding
> very slowly even after full vacuum analyze (select count(*) from
> some_table_having_18000_records was taking 18 Sec).
>
> We
Hello Friends,
We were having a database in pgsql7.4.2 The database was
responding very slowly even after full vacuum analyze (select count(*) from some_table_having_18000_records was taking 18
Sec).
We took a backup of that db and restored it back. Now the
same db on same PC is res
