of WAL-log reply.
Now, if your database is DML-heavy recovery won't be very fast, so you
might want to take
base backups more frequently. Or better -- set up a standby server
which will constantly
reply the backups.
Regards,
Dawid Kuroczko
PS: And before setting a policy, do try
On Fri, Feb 22, 2008 at 3:54 PM, Tom Lane <[EMAIL PROTECTED]> wrot>
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes:
> > I have recently found a nice utility called memstat (which shows how
> > much of private
> > (not shared)) memory each process us
Hi there,
I have recently found a nice utility called memstat (which shows how
much of private
(not shared)) memory each process uses. What kind of surprised me was
the amount
of memory that is used by PL/pgSQL (one more reason not to provide it
by default? ;-)).
For example:
# sysctl -w|grep pl
On 10/26/07, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Thu, 2007-10-25 at 22:52 -0700, David Young wrote:
> > FATAL: incorrect checksum in control file
>
> Did you move the old data files to the new server? If so, it won't work.
> Dump your 32-bit database with 32-bit binaries, and loa
On 10/4/07, yogesh <[EMAIL PROTECTED]> wrote:
> Hello Friends,
>
> I have a Problem in Accessing Arrays in the Postgres.
> The Description of my problem is given
> here:---
> I have two array of numeric types. One That stores the IDs and Other
> Store their va
On 10/5/07, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
>
>
> Is there a way to execute an external program from within a stored
> procedure?
> In pl/pgsql it does not appear to be supported.
> Will pl/perl allow me to do so?
PL/PerlU
^ -- 'U' is for unsafe.
PL/Perl runs in tainted
On 6/18/07, Ray Stell <[EMAIL PROTECTED]> wrote:
On Mon, Jun 18, 2007 at 11:24:45AM +0200, Dawid Kuroczko wrote:
> On 6/17/07, Ray Stell <[EMAIL PROTECTED]> wrote:
> >Or as PDF at at
> >http://www.portcullis.co.uk/uplds/whitepapers/Having_Fun_With_PostgreSQL.pdf
>
&
On 6/17/07, Ray Stell <[EMAIL PROTECTED]> wrote:
For the security minded:
Nico Leidecker <[EMAIL PROTECTED]> posted this to bugtraq yesterday, fyi.
"I'd like to present a paper about security issues with PostgreSQL. The paper
describes weaknesses in the configuration that may
+allow attackers
Hello!
There is a good chance that I'll be trying to deploy PostgreSQL
on some older IBM Power5+ machines (running AIX 5.2 or 5.3).
I wonder if any of you coukl give me some hints on using PostgreSQL
on that platform?
Installation
Looks like I'll be compiling from source (or are there any good
Having done a series of
CREATE TEMP TABLE snap_user_idx AS SELECT * FROM pg_stat_user_indexes;
SELECT t1.indexrelname,t1.idx_scan-t0.idx_scan as idx_scan,
t1.idx_tup_read-t0.idx_tup_read AS idx_tup_read,
t1.idx_tup_fetch-t0.idx_tup_fetch as idx_tup_fetch
FROM pg_stat_user_indexes t1 JOIN snap_u
On 6/25/06, Chris Hoover <[EMAIL PROTECTED]> wrote:
Just curious,What are most of you setting your vacuum and autovacuum parameters to for your 8.x databases. I just turned on autovacuuming on one of my db servers and went with a very conservative vacuum_cost_delay of 200 and vacuum_cost_limit of
On 7/18/05, FM <[EMAIL PROTECTED]> wrote:
> Hello,
> Is it possible to backup postgresql databases without locking tables.
You mean, like:
http://www.postgresql.org/docs/current/static/backup-online.html
Or do you need a "dump" of database (then use pg_dumpall).
Regards,
Dawid
-
On 7/20/05, Rafal Kedziorski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I wan't add new column to this table:
>
> CREATE SEQUENCE abo_product_2_user_seq;
>
> CREATE TABLE abo_product_2_user (
>abo_product_2_user_id BIGINT NOT NULL DEFAULT
> NEXTVAL('abo_product_2_user_seq'),
>abo_product
On 7/8/05, Düster Horst <[EMAIL PROTECTED]> wrote:
> I try to join two tables whereas some column values do have NULL values with
> the following query:
>
> select table1.column from table1, table2 where table1.column=table2.column
>
> table1.column and table2.column may have NULL values. The pro
On 6/9/05, KÖPFERL Robert <[EMAIL PROTECTED]> wrote:
> Short question:
>
> Is it enugh to have stripping on a disk array?
> Are table spaces then of less use than the actual stripping? So will just
> stripping give me more O/I-performance?
Short answer: if you make one striping partition -- you
> > No, there is not. Does anyone want to suggest a possible implementation
> > for the TODO list?
> I would like to see a combination of number of login failures and a
> timeout, configurable via the conf file. Say, X login failures
> disables further logins for that account for Y minutes.
>
>
On Tue, 25 Jan 2005 22:06:49 -0500, Chris Hoover
<[EMAIL PROTECTED]> wrote:
> From: Chris Hoover <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Tue, 25 Jan 2005 16:27:45 -0500
> Subject: how to determine storage size of a numeric column
> I'm running 7.3.4, and am trying to calculate the space
On Thu, 13 Jan 2005 12:20:41 +, Dick Davies
<[EMAIL PROTECTED]> wrote:
> > But only if either setuid root or executed by root. Hey, on my
> > system even /bin/sh is owned by root; it would be funny of it
> > executed as root
> C'mon folks, the guy obviously made a booboo - no need to rub his
>
On Wed, 12 Jan 2005 20:52:16 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> >Whatever, I'll keep root only for absolutely restricted use & install
> >under a separate user account. Works just fine & it makes the auditors
> >& sysadmin feel better.
> I don't argue the point of using root. I ag
19 matches
Mail list logo
