what tool is suitable for profiling store procedure in postgresql? sql server
has sql profiles, how about postgresql?
Am 22.03.2012 18:21, schrieb Heiko Wundram:
Am 22.03.2012 15:48, schrieb Tom Lane:
There was a memory leak in the last-but-one releases for index
operations on inet and cidr datatypes, so I'm wondering if that
explains your problem ...
I'll be updating pgsql now and
then recheck the import.
On Fri, Mar 23, 2012 at 11:16 AM, Geek Matter geekmat...@yahoo.com wrote:
what tool is suitable for profiling store procedure in postgresql? sql
server has sql profiles, how about postgresql?
You can use the pg_stat_statements
On Fri, 2012-03-23 at 00:16 -0700, Geek Matter wrote:
what tool is suitable for profiling store procedure in postgresql? sql server
has sql profiles, how about postgresql?
The EDB PL/pgsql profiler tool is probably the easier tool to work with
if you want to profile PL/pgsql functions. That's
Am 23.03.2012 06:45, schrieb Gerhard Wiesinger:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
Just corious: What is causing this many transactions?
Cheers,
Frank
--
Sent via pgsql-general
Hi,
On 23 March 2012 19:14, Frank Lanitz fr...@frank.uvena.de wrote:
Am 23.03.2012 06:45, schrieb Gerhard Wiesinger:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
Just corious: What is
On 23.03.2012 06:45, Gerhard Wiesinger wrote:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
As PostgreSQL uses transaction IDs (XIDs) in the range of 2^31 they
would turn around in about one
Hi everybody,
is there any fdw_handler for postgresql available (pg to pg)?
I saw thread
http://archives.postgresql.org/pgsql-general/2011-09/msg00525.php, need to
know if something has been changed
Thanks in advance Regards,
Bartek
On Fri, 2012-03-23 at 12:26 +0100, Bartosz Dmytrak wrote:
Hi everybody,
is there any fdw_handler for postgresql available (pg to pg)?
I saw thread
http://archives.postgresql.org/pgsql-general/2011-09/msg00525.php, need to
know if something has been changed
Not yet. There is one in the
On 03/22/2012 10:45 PM, Gerhard Wiesinger wrote:
Hello,
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
As PostgreSQL uses transaction IDs (XIDs) in the range of 2^31 they
would turn around in
On 03/23/2012 04:26 AM, Bartosz Dmytrak wrote:
Hi everybody,
is there any fdw_handler for postgresql available (pg to pg)?
I saw thread
http://archives.postgresql.org/pgsql-general/2011-09/msg00525.php, need
to know if something has been changed
Might be able to make it work using Multicorn
thanks,
I am waiting...
Pozdrawiam,
Bartek
2012/3/23 Guillaume Lelarge guilla...@lelarge.info
On Fri, 2012-03-23 at 12:26 +0100, Bartosz Dmytrak wrote:
Hi everybody,
is there any fdw_handler for postgresql available (pg to pg)?
I saw thread
Hi
We're having two servers one of which is productive, the other used for backup
and staging. Each has pg-9.1 installed and the relevant filesystem parts are
regularly rsynced.
The last missing piece is streaming replication from the production to the
staging server. On production, pg holds two
Am 23.03.2012 14:23, schrieb Adrian Klaver:
I would say either they got the numbers wrong or someone is pulling
your leg. That rate is not going to happen.
Maybe twitter or facebook all in all...
Cheers,
Frank
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Arvind Singh wrote:
i have sorted out the problem on
The columns that are not quoted are guaranteed not to contain a
comma.
Good.
But i have another query, the structure of PG Log CSV as mentioned in
manual and as below has 24
columns
I'd like to switch to PITR backups, but have limited disk space. Is there
a way to get a ballpark estimate by monitoring a running system, without
actually creating the WAL files and risking filling a filesystem?
Mike
2012/3/23 Mike Blackwell mike.blackw...@rrd.com
I'd like to switch to PITR backups, but have limited disk space. Is there
a way to get a ballpark estimate by monitoring a running system, without
actually creating the WAL files and risking filling a filesystem?
Usually each wal segment size
On 03/22/12 10:45 PM, Gerhard Wiesinger wrote:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
bullpucky. that's 2 transactions per NANOSECOND. light can travel
about 6 in that time. half a
On Wed, Mar 21, 2012 at 6:47 PM, Rory Campbell-Lange
r...@campbell-lange.net wrote:
I'd be grateful for comments on whether to go with a server with the A
or B spec. Both servers have the following in common:
E5620 Quad-Core / 4x 2.40GHz
LSI MegaRAID SAS 9260-4i with BBU (6Gbps)
48
On Wed, Mar 21, 2012 at 3:31 PM, Kjetil Nygård polpo...@gmail.com wrote:
We wonder if someone could give some hardware / configuration specs for
large PostgreSQL installations.
We're interested in:
- Number of CPUs
- Memory on the server
- shared_buffers
- Size
On Fri, Mar 23, 2012 at 10:01 AM, Vick Khera vi...@khera.org wrote:
On Wed, Mar 21, 2012 at 3:31 PM, Kjetil Nygård polpo...@gmail.com wrote:
We wonder if someone could give some hardware / configuration specs for
large PostgreSQL installations.
We're interested in:
- Number of CPUs
On Fri, Mar 23, 2012 at 11:28 AM, Merlin Moncure mmonc...@gmail.com wrote:
would love to see some performance #s from your server when it's all set up...
I plan on doing some. This will also be my very first non-FreeBSD
server (it is also running a custom app we just bought, and that
requires
On 23.03.2012 11:16, Jan Kesten wrote:
On 23.03.2012 06:45, Gerhard Wiesinger wrote:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
As PostgreSQL uses transaction IDs (XIDs) in the range of 2^31
On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger li...@wiesinger.com wrote:
On 23.03.2012 11:16, Jan Kesten wrote:
On 23.03.2012 06:45, Gerhard Wiesinger wrote:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31
On 23.03.2012 11:16, Jan Kesten wrote:
On 23.03.2012 06:45, Gerhard Wiesinger wrote:
With a database admin of a commercial database system I've discussed
that they have to provide and they also achieve 2^31 transactions per
SECOND!
As PostgreSQL uses transaction IDs (XIDs) in the range of 2^31
Hi all,
I am inserting apache log into into a database. Seem to have a little
problem with this function:
create or replace function insert_webstat(
ivhost text,
iip inet,
isessid text,
ihittime timestamp,
iurl text,
istatus integer,
Merlin Moncure mmonc...@gmail.com writes:
On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger li...@wiesinger.com
wrote:
So I think XID overflow should be planned for one of the next PostgreSQL
releases.
two mitigating factors:
1. read only transactions do not increment xid counter
Yes.
On 03/23/12 9:17 AM, Gerhard Wiesinger wrote:
So in that time autovacuum is triggered.
autovacuum runs pretty much continuously in the background, its not an
on/off thing.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
On Fri, Mar 23, 2012 at 1:57 PM, Tom Lane t...@sss.pgh.pa.us wrote:
2. xid wraparound counter is per table.
That unfortunately isn't so, the XID counter is global to an installation.
yup -- thinko: I was thinking about oid counter, not xid. thanks
merlin
--
Sent via pgsql-general mailing
On Fri, 23 Mar 2012, John R Pierce wrote:
On 03/23/12 9:17 AM, Gerhard Wiesinger wrote:
So in that time autovacuum is triggered.
autovacuum runs pretty much continuously in the background, its not an on/off
thing.
Yes, I know. I ment that it runs at least once in 1.5 days.
Ciao,
Gerhard
On Fri, 23 Mar 2012, Tom Lane wrote:
Merlin Moncure mmonc...@gmail.com writes:
On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger li...@wiesinger.com wrote:
So I think XID overflow should be planned for one of the next PostgreSQL
releases.
two mitigating factors:
1. read only transactions
Today I learned that . . .
the firing of even internally generated constraint triggers is affected by
the value of [session_replication_role].
Sadly, I had previously assumed that such internal triggers did not care
about [s_r_r].
Also learned that . . .
when a FK constraint gets made, its
On 03/23/2012 12:12 PM, Gerhard Wiesinger wrote:
On Fri, 23 Mar 2012, John R Pierce wrote:
On 03/23/12 9:17 AM, Gerhard Wiesinger wrote:
So in that time autovacuum is triggered.
autovacuum runs pretty much continuously in the background, its not an
on/off thing.
Yes, I know. I ment that
david.sahag...@emc.com writes:
Is the a way to configure Postgres such that tgenabled = ' A' automatically
when the FK constraint gets made ?
No. Why do you think that would be a good idea? ISTM it'd lead to the
action being taken twice on the slave.
regards, tom
Hi I seem to have an 8.3.9 database with a broken xlog,
PANIC: heap_insert_redo: invalid max offset number
My plan is to run pg_resetxlog.
Hopefully it then starts up.
Test recent data as thoroughly as possible - (script some Select * ' s?)
If ok - curse ops and their raid caches
If not - curse
Hi,
I want to use statistical functions, such as variance(), stddev() and
covar_samp(), to compute some basic statistics of my data. I have
strict requirement for the numerical accuracy of the results. So, I
want to know whether the implementation of these functions are
numerically stable. For
Dear sir,
we are recent users of Postgres and wish to be more aware and soak up the
activities around the DB.
we used to develop more on MySql , SQl Server combo
Now we are using PG 9.0.5 , NPGSQL + Visual CSharp , Java
Is http://www.pgcon.org/2012/?2nd
a valid and certified Postgres
VoltDB maybe
- Original Message -
On 06:31 AM 03/23/2012 Frank Lanitz wrote:
Am 23.03.2012 14:23, schrieb Adrian Klaver:
I would say either they got the numbers wrong or someone is pulling
your leg. That rate is not going to happen.
Maybe twitter or facebook all in all...
Cheers,
38 matches
Mail list logo
