On 2012-06-06, Ben Carbery wrote:
> In the current environment I am given a single VHDD which I have not
> partitioned at all. The SAN performance is pretty good, but we have noticed
> slowdowns at various times.. The database does a lot of logging - constant
> small writes, with some probably in
On 2012-06-05, Aleksander Rozman wrote:
> Now I am not sure two of this directories are old databases, but I think
> they are... Is there a way to register one of this databases into new
> installation (I am sure that directory "1" is old postgres database, and
> "11563" is my database I want
On 2012-06-08, Zenaan Harkness wrote:
> I'd like find out how often the JVM starts up eg based on queries or
> sessions or connections or what... didn't know it was potentially
> woeful. In particular re "Because Pg doesn't re-use backends, there's
> a huge amount of JVM startup and shutdown cost
On 6/6/2012 2:35 AM, Daniel Verite wrote:
Aleksander Rozman wrote:
Now I am not sure two of this directories are old databases, but I think
they are... Is there a way to register one of this databases into new
installation (I am sure that directory "1" is old postgres database, and
"115
Hi There,
I'd like to be able to run the contents of an external SQL file from Perl.
Something akin to:
$dbh->do( '\i /home/david/run_me.sql' );
However this fails, and I assume that is because the \i is a client command. Is
there a way to run the contents of an external SQL from a Per d
On Sat, Jun 9, 2012 at 3:29 PM, David Williams
wrote:
>
> Hi There,
>
> I'd like to be able to run the contents of an external SQL file from Perl.
> Something akin to:
>
> $dbh->do( '\i /home/david/run_me.sql' );
>
> However this fails, and I assume that is because the \i is a client command.
> do many of the statistical queries use the whole month's data?
> have you considered partitioning the log table by day? if you can
> reduce the number of rows involved in the table-scans by partitioning
> it'll be help performance.
>
I am summarising by hour, day, week and month. So I guess par
Hi All,
We are having a problem with our streaming replication read only node. It has
crashed a few times with a couple of different reasons, mostly "segmentation
fault". The latest log are listed below:
2012-05-30 23:56:37.385 UTC::: LOG: server process (PID 19476) was terminated
by signa
On 2012-06-08 08:39, Craig Ringer wrote:
On 06/07/2012 10:26 PM, Condor wrote:
Hello ppl,
I read in internet and in this mailing list, when some one asking
about load balance,
most of the answers is: pgpool.
I want to asking how stable is pgpool ? How much query can handle ?
What load averag
On 06/10/12 11:26 PM, Condor wrote:
Im not sure, just looking how to make load balance. I have a small
database around 20 gb,
but I expect to join another database on different scheme and Im
looking for solution
about load balance or some cache mechanism. Bad part is one row from
db is read onc
10 matches
Mail list logo
