Why not give it a try once? Dump and restore once and see for yourself.
You'd have done that by now, but if you haven't do give it a try instead of
waiting any more. You may learn a thing or two in the process...
Best regards,
--
[EMAIL PROTECTED]
[EMAIL PROTECTED] gmail | hotmail | indiatimes |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/01/07 20:40, Dragan Zubac wrote:
> Hello
>
> I have a stored procedure which does the billing stuff
> in our system,it works ok,but if I put in
> production,where there is some 5-10 billing events per
> second,the whole database slows down. It w
Hello
I have a stored procedure which does the billing stuff
in our system,it works ok,but if I put in
production,where there is some 5-10 billing events per
second,the whole database slows down. It won't even
drop some test table,reindex,vacuum,things which were
done before in the blink of an eye
Joshua D. Drake escribió:
On Sat, 01 Dec 2007 15:22:38 -0500
I wonder what I'm supposed to do with my debian installation since
there doesn't seem to be any such thing as pg_resetxlog. Or is it
hiding somewhere?
I don't recall if it is in contrib or not.. try?:
apt-file is your friend:
apt
Tom Allison escribió:
I wonder what I'm supposed to do with my debian installation since there
doesn't seem to be any such thing as pg_resetxlog. Or is it hiding
somewhere?
On one debian I have:
/usr/lib/postgresql/8.1/bin/pg_resetxlog
/usr/lib/postgresql/8.2/bin/pg_resetxlog
---
On Sat, 01 Dec 2007 15:32:50 -0500
Tom Allison <[EMAIL PROTECTED]> wrote:
> I tracked it down and did a reset.
> I only have one large table right now.
>
> And now I've decided to start using fsync=on!!! :)
change wal_sync_method to open_sync and fsync=on isn't nearly as bad as
it sounds.
josh
On Sat, 01 Dec 2007 15:22:38 -0500
Tom Allison <[EMAIL PROTECTED]> wrote:
regards, tom lane
>
>
> Cool, thanks.
>
> I wonder what I'm supposed to do with my debian installation since
> there doesn't seem to be any such thing as pg_resetxlog. Or is it
> hiding somewhere?
I don't recall
Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
record
Ugh :-(. pg_resetxlog should get you back into the database, but it's
anybody's guess whether and how badly the contents will be corrupted.
I would recommend try
Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
record
Ugh :-(. pg_resetxlog should get you back into the database, but it's
anybody's guess whether and how badly the contents will be corrupted.
I would recommend try
On 01.12.2007, at 09:35, Ragnar Heil wrote:
WHich solution are you using now, Guido?
For the one installation we needed multi-master, we have FrontBase
running.
PostgreSQL multi-master just wasn't "right" for us. Too much hardware
needed to get real redundancy, the setup is too complex a
At 6:15 PM -0500 11/30/07, Greg Smith wrote:
On Fri, 30 Nov 2007, Guido Neitzer wrote:
Actually - In our test if just used with a similar load as pgbench
(e.g. typical web applications) Mac OS X 10.4.7 performed better
then Yellow Dog Linux (I was testing with G5 hardware) on the same
hardwa
WHich solution are you using now, Guido?
Has anyone made experiences with cybercluster? I am thankful to hear
comments
and especially comparision to other products
thanks
Ragnar
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Guido Neitzer
> Sen
Alvaro Herrera wrote:
>Rainer Bauer wrote:
>> Ok, I expected that. Does this work:
>> ALTER TABLE foo CLUSTER ON index_name SET TABLESPACE new_tablespace
>>
>> I.e. is the table moved to the other tablespace and clustered at the same
>> time
>> or are these independant operations?
>
>No, the ALT
On Fri, Nov 30, 2007 at 08:10:11AM +0100, Luca Ferrari wrote:
> On Thursday 29 November 2007 Joshua D. Drake's cat, walking on the keyboard,
> wrote:
> > If you are not lazy you can push outside the standard hibernate
> > methods and produce very usable code but then you have to wonder
> > why you
By the way I found also another tool called CyberCluster that will
probably not make my choice easier ;)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Sat, 01 Dec 2007, Martin Marques wrote:
>> Also check whether a disks have write-caching turned off - it should.
>> On Linux the command is:
>> # hdparm -W /dev/sda
>> /dev/sda:
>> write-caching = 0 (off)
>
> Uh? That command as was written lacks an argument for -W (0/1). From
Tomasz Ostrowski escribió:
On Sat, 01 Dec 2007, rihad wrote:
fsync = on;
synchronous_commit = off;
full_page_writes = off;
Thanks for any insights or clarifying missed points.
Also check whether a disks have write-caching turned off - it should.
On Linux the command is:
# hdparm -W /d
On Sat, 01 Dec 2007, rihad wrote:
> fsync = on;
> synchronous_commit = off;
> full_page_writes = off;
> Thanks for any insights or clarifying missed points.
Also check whether a disks have write-caching turned off - it should.
On Linux the command is:
# hdparm -W /dev/sda
/dev/sda
"rihad" <[EMAIL PROTECTED]> writes:
> Hi, would full_page_writes=off increase the risk of inconsistency or db
> corruption in 8.3 and FreeBSD 7?
yes.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
---
"Martijn van Oosterhout" <[EMAIL PROTECTED]> writes:
> On Fri, Nov 30, 2007 at 11:27:24AM -0500, Josh Harrison wrote:
>> Thanks for your reply
>> Is there a way to get them not to use the
>> heap for intermediate result and go to heap only for final data? This will
>> drastically improve the perfo
> --- Original Message ---
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Sent: 30/11/07, 23:28:33
> Subject: [GENERAL] libeay32.dll and libpq.dll
>
> I'm working on a Windows application that will connect to a Postgresql
> database without having through ODBC.
>
> I'm u
Hi, would full_page_writes=off increase the risk of inconsistency or db
corruption in 8.3 and FreeBSD 7?
fsync = on;
Definitely "on", as single power outage after three years is guaranteed
to make your life interesting otherwise.
synchronous_commit = off;
Can be "off" in my case as I'm not do
22 matches
Mail list logo
