On Wed, 2006-05-17 at 00:36 -0400, Tom Lane wrote:
> Jeff Frost <[EMAIL PROTECTED]> writes:
> > On Tue, 16 May 2006, Simon Riggs wrote:
> >> Whatever happened between 02:08 and 02:14 seems important.
>
> > I have the logs and after reviewing /var/log/messages for that time period,
> > there is no
Simon Riggs <[EMAIL PROTECTED]> writes:
> You'll have to explain a little more. I checked the archives...
I was thinking of
http://archives.postgresql.org/pgsql-hackers/2004-01/msg00530.php
full explanation here:
http://archives.postgresql.org/pgsql-hackers/2004-01/msg00606.php
> The "lurking fee
On Wed, 2006-05-17 at 10:01 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > You'll have to explain a little more. I checked the archives...
>
> I was thinking of
> http://archives.postgresql.org/pgsql-hackers/2004-01/msg00530.php
> full explanation here:
> http://archives.post
Ok, I'm still working on the possibility of turning autovacuum on.Question, I have a tables that are multi GB. When I run the threshold calculations using "normal" values, it seems that my large important tables would almost never be vacuumed. Here is an example, in my largest database, my most i
On Wed, 17 May 2006, Tom Lane wrote:
The "lurking feeling" scenario above might or might nor be an issue
here, but I can't see how the archiver could be involved at all.
Well, I don't see it either; at this point we're waiting on Jeff to
provide some harder evidence ...
Was the 3,000 transac
Hi
Every night, a delete of about 50 million rows occurs on a
table. Do we need to explicitly vacuum the table or will autovacuum handle the
large deletes without affecting performance. I am trying to determine whether
or not I should completely rely on autovacuum or also tinker with ma
Sriram Dandapani wrote:
> Every night, a delete of about 50 million rows occurs on a table. Do we
> need to explicitly vacuum the table or will autovacuum handle the large
> deletes without affecting performance. I am trying to determine whether
> or not I should completely rely on autovacuum or a
About 5-10 million rows stay after deletion. There are a few other
tables where the daily deletion totals about 3-6 million.
Would a vacuum full/cluster affect other operations. These tables have a
24x7 high data insertion rate.
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROT
On Wed, May 17, 2006 at 11:53:44AM -0400, Chris Hoover wrote:
> Ok, I'm still working on the possibility of turning autovacuum on.
>
> Question, I have a tables that are multi GB. When I run the threshold
> calculations using "normal" values, it seems that my large important tables
> would almost
[EMAIL PROTECTED] ("Sriram Dandapani") writes:
> Every night, a delete of about 50 million rows occurs on a table. Do
> we need to explicitly vacuum the table or will autovacuum handle the
> large deletes without affecting performance. I am trying to
> determine whether or not I should completely r
On Wed, May 17, 2006 at 01:39:35PM -0700, Sriram Dandapani wrote:
> About 5-10 million rows stay after deletion. There are a few other
> tables where the daily deletion totals about 3-6 million.
The default autovac settings will only vacuum a table after 40% of the
rows are dead. That seems prett
[EMAIL PROTECTED] ("Sriram Dandapani") writes:
> About 5-10 million rows stay after deletion. There are a few other
> tables where the daily deletion totals about 3-6 million.
It would appear there is something fairly not-sane about the process,
then. You delete about 90% of the day's data from
Looks like partitioning may seem the way to go. I have been hesitant
about using partitioning as the feature is very new. How do I manage the
free space map if I do not use partitioning?
Thanks for your inputs
Sriram
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
On Wed, May 17, 2006 at 03:18:45PM -0700, Sriram Dandapani wrote:
> Looks like partitioning may seem the way to go. I have been hesitant
> about using partitioning as the feature is very new. How do I manage the
> free space map if I do not use partitioning?
Make it very large. Or read the detaile
Jeff Frost <[EMAIL PROTECTED]> writes:
> Was the 3,000 transactions per minute helpful? What other evidence should I
> be looking for?
Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to
On Wed, 17 May 2006, Tom Lane wrote:
Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to expose it in a simple test case. I'm up to my armpits
in other stuff and don't have time to try i
On Wed, 17 May 2006, Jeff Frost wrote:
On Wed, 17 May 2006, Tom Lane wrote:
Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to expose it in a simple test case. I'm up to my armpits
in
Jeff Frost <[EMAIL PROTECTED]> writes:
> I seem to get alot of these:
> May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename
> file
> "pg_xlog/archive_status/00010001.ready" to
> May 17 21:34:04 discord postgres[20573]: [5-2]
> "pg_xlog/archive_status/00
sandhya escribió:
Hi,
Already i have postgres server running on my windows system.Suddenly
when i open it didn't open and when i run and see in the services...I am
getting the following.
I have this problem in a W2000 system. The solution is write again de
password to user postgres in window
OS = Solaris 9
PERL v = 5.8.7
postgreSQL = 8.0.1
I'm getting the following error when attempting to interface through my
web browser, immediately after supplying the login information.
Software error:
install_driver(Pg) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/
Jeff Zhong wrote:
I installing postgre SQL on Windowx XP
Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database
Server 8.1' (pgsql-8.1) failed to start. Verify that you have
sufficient privileges to start system services.
I got this error when I try to install postgresql on wi
Title: Error in Access
Hi,
My database users are getting following error:
ODBC-call failed
Error while executing query
Error: ItsWriteBlock: failed to write block 1 of temporary file
Perhaps out of disk space (#1)
This happens in Access. Could anyone shed some light on this? Thank yo
Hi All,
I am currently using PostgreSQL 8.1.3 and am trying to create an
updatable view with two (or more) joined tables and I also would like to
have the ability to indicate implicitly the value of the serial primary
key fields.
I have the following two tables:
CREATE TABLE purchase (
pu
Title: PGSQL Database Recovery in Portland Oregon Area needed ASAP
I have a client that is running an older version of Lyris List Manager against PostGres 7.1.2, that has crashed their database beyond my ability to recover it. The error that I am getting when we try and restart the database i
On Tue, May 16, 2006 at 09:53:54AM -0700, Mark Holm wrote:
> I have a client that is running an older version of Lyris List
> Manager against PostGres 7.1.2, that has crashed their database
> beyond my ability to recover it. The error that I am getting when we
> try and restart the database is:
Ve
On Thu, 18 May 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I seem to get alot of these:
May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename file
"pg_xlog/archive_status/00010001.ready" to
May 17 21:34:04 discord postgres[20573]: [5-2]
"p
On Wed, 17 May 2006, Jeff Frost wrote:
And in the window where I started postgres via pg_ctl, I had this:
cat: pg_xlog/0001000E: No such file or directory
cat: pg_xlog/0001000E: No such file or directory
Hrmmm...my pgbench died with an integer out of range erro
27 matches
Mail list logo
