pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres configuration
5+ messages / 4 participants
[nested] [flat]
* postgres configuration
@ 2007-03-13 17:14 Sumeet <asumeet@gmail.com>
2007-03-13 18:06 ` Re: postgres configuration Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-03-13 21:30 ` Re: postgres configuration Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Sumeet @ 2007-03-13 17:14 UTC (permalink / raw)
To: pgsql-sql
Hi All,
Sorry if this is the wrong list to ask this question.
My Vacuum's are running very very slow and expecially when vacuuming indexes
in large tables of size in 5-10 gigabytes,
can some one help me determine the parameters for postgres.conf which will
help me vacuum fast. I'm running postgres on a server with 32 gigs of ram
and 8 processors.
Thanks,
Sumeet.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres configuration
2007-03-13 17:14 postgres configuration Sumeet <asumeet@gmail.com>
@ 2007-03-13 18:06 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-03-13 20:48 ` Re: postgres configuration Sumeet <asumeet@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Andrej Ricnik-Bay @ 2007-03-13 18:06 UTC (permalink / raw)
To: Sumeet <asumeet@gmail.com>; pgsql-sql
On 3/14/07, Sumeet <asumeet@gmail.com> wrote:
> Hi All,
Hi,
> Sorry if this is the wrong list to ask this question.
General woould have been better :)
> My Vacuum's are running very very slow and expecially when vacuuming indexes
> in large tables of size in 5-10 gigabytes,
> can some one help me determine the parameters for postgres.conf which will
> help me vacuum fast. I'm running postgres on a server with 32 gigs of ram
> and 8 processors.
And the disk subsystem is .... ?
> Thanks,
> Sumeet.
Cheers,
Andrej
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres configuration
2007-03-13 17:14 postgres configuration Sumeet <asumeet@gmail.com>
2007-03-13 18:06 ` Re: postgres configuration Andrej Ricnik-Bay <andrej.groups@gmail.com>
@ 2007-03-13 20:48 ` Sumeet <asumeet@gmail.com>
2007-03-13 21:07 ` Re: postgres configuration Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 5+ messages in thread
From: Sumeet @ 2007-03-13 20:48 UTC (permalink / raw)
To: Andrej Ricnik-Bay <andrej.groups@gmail.com>; +Cc: pgsql-sql
The only info i have is
Apple xRaid drive array with 14 400GB drives for a total of 5 TB storage
I have around 10-15 indexes for each tables. does the number of indexes slow
down the vacuum process?
indexes are compund indexes on multiple fields.
-Sumeet
On 3/13/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
>
> On 3/14/07, Sumeet <asumeet@gmail.com> wrote:
> > Hi All,
> Hi,
>
> > Sorry if this is the wrong list to ask this question.
> General woould have been better :)
>
> > My Vacuum's are running very very slow and expecially when vacuuming
> indexes
> > in large tables of size in 5-10 gigabytes,
> > can some one help me determine the parameters for postgres.conf which
> will
> > help me vacuum fast. I'm running postgres on a server with 32 gigs of
> ram
> > and 8 processors.
> And the disk subsystem is .... ?
>
>
>
> > Thanks,
> > Sumeet.
> Cheers,
> Andrej
>
--
Thanks,
Sumeet Ambre
Master of Information Science Candidate,
Indiana University.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres configuration
2007-03-13 17:14 postgres configuration Sumeet <asumeet@gmail.com>
2007-03-13 18:06 ` Re: postgres configuration Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-03-13 20:48 ` Re: postgres configuration Sumeet <asumeet@gmail.com>
@ 2007-03-13 21:07 ` Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2007-03-13 21:07 UTC (permalink / raw)
To: Sumeet <asumeet@gmail.com>; +Cc: Andrej Ricnik-Bay <andrej.groups@gmail.com>; pgsql-sql
On Tue, 2007-03-13 at 15:48, Sumeet wrote:
> On 3/13/07, Andrej Ricnik-Bay <andrej.groups@gmail.com> wrote:
> On 3/14/07, Sumeet <asumeet@gmail.com> wrote:
> > Hi All,
> Hi,
>
> > Sorry if this is the wrong list to ask this question.
> General woould have been better :)
>
> > My Vacuum's are running very very slow and expecially when
> vacuuming indexes
> > in large tables of size in 5-10 gigabytes,
> > can some one help me determine the parameters for
> postgres.conf which will
> > help me vacuum fast. I'm running postgres on a server with
> 32 gigs of ram
> > and 8 processors.
> And the disk subsystem is .... ?
>
> The only info i have is
>
> Apple xRaid drive array with 14 400GB drives for a total of 5 TB
> storage
> I have around 10-15 indexes for each tables. does the number of
> indexes slow down the vacuum process?
> indexes are compund indexes on multiple fields.
Yes, indexes have to be vacuumed, and compound fields tend to get larger
at a geomtric rate as you add columns.
Apple XRaids have gotten some pretty "meh" reviews in the past. Does
this one have battery backed caching? (a good thing) Is it configured as
RAID-5 (a not so good thing)
If so, can you reconfigure it as RAID1+0 or do you need every terabyte
of storage you can get?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres configuration
2007-03-13 17:14 postgres configuration Sumeet <asumeet@gmail.com>
@ 2007-03-13 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2007-03-13 21:30 UTC (permalink / raw)
To: Sumeet <asumeet@gmail.com>; +Cc: pgsql-sql
Sumeet <asumeet@gmail.com> writes:
> My Vacuum's are running very very slow and expecially when vacuuming indexes
> in large tables of size in 5-10 gigabytes,
> can some one help me determine the parameters for postgres.conf which will
> help me vacuum fast. I'm running postgres on a server with 32 gigs of ram
> and 8 processors.
What postgres version?
8.2 should be considerably faster than prior releases due to Heikki's
fixes to let indexes be scanned in physical order during VACUUM.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-03-13 21:30 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-13 17:14 postgres configuration Sumeet <asumeet@gmail.com>
2007-03-13 18:06 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-03-13 20:48 ` Sumeet <asumeet@gmail.com>
2007-03-13 21:07 ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-03-13 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox