On Tue, Jan 17, 2006 at 09:17:41PM -0800, [EMAIL PROTECTED] wrote:
> Hi All,
>
> I haven't vacuum/analysed the D2 database or for that matter D1.
> In fact I have never used VACUUM before.
> Maybe that is the problem.
>
> What are the benefits of the VACUUM command in PostgreSQL?
VACUUM is as cl
On Jan 18, 2006, at 14:17 , [EMAIL PROTECTED] wrote:
What are the benefits of the VACUUM command in PostgreSQL?
The docs have quite a bit of information on this. For a start, take a
look at:
http://www.postgresql.org/docs/current/interactive/
maintenance.html#ROUTINE-VACUUMING
Recently,
On Thu, 2006-01-19 at 16:46, Michael Glaesemann wrote:
> On Jan 18, 2006, at 14:17 , [EMAIL PROTECTED] wrote:
>
> > What are the benefits of the VACUUM command in PostgreSQL?
>
> The docs have quite a bit of information on this. For a start, take a
> look at:
> http://www.postgresql.org/docs/cu
On Tue, Jan 17, 2006 at 09:17:41PM -0800, [EMAIL PROTECTED] wrote:
> I haven't vacuum/analysed the D2 database or for that matter D1.
> In fact I have never used VACUUM before.
> Maybe that is the problem.
>
> What are the benefits of the VACUUM command in PostgreSQL?
See the section on vacuuming
Hi All,
I haven't vacuum/analysed the D2 database or for that matter D1.
In fact I have never used VACUUM before.
Maybe that is the problem.
What are the benefits of the VACUUM command in PostgreSQL?
Thanks in advance
- Kishore
---(end of broadcast)-
Have you vacuum'd and/or analyzed D2?
http://www.postgresql.org/docs/8.1/static/maintenance.html
http://www.postgresql.org/docs/8.1/static/sql-analyze.html
James Robinson
Socialserve.com
---(end of broadcast)---
TIP 3: Have y
On 17 Jan 2006 01:22:20 -0800, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0.
>
> I have two databases ( identical schema and similar data ).
>
> One database, D1 contains the actual data of a Production Application.
> T
On Jan 17, 2006, at 18:22 , [EMAIL PROTECTED] wrote:
I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0.
I'd highly recommend upgrading. The current release is 8.1.2. If you
can't upgrade to 8.1, at least upgrade to the latest point release of
7.3, which is 7.3.13. There ar
Hi All,
I am using PostgreSQL 7.3.2 on a server running Red Hat Linux 9.0.
I have two databases ( identical schema and similar data ).
One database, D1 contains the actual data of a Production Application.
The other D2 contains dummy data which is used during development and
testing of the appli