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 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
(http://www.postgresql.org/docs/9.1/interactive/pgstatstatements.html)
extension to do
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 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 causing this many
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
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 abou
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 and
thanks,
I am waiting...
Pozdrawiam,
Bartek
2012/3/23 Guillaume Lelarge
> 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/msg00
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 ch
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
> http://www.postgresql.org/docs/9.1/static/runtim
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
> 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 is 16MB (1677721
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
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 GB PC3-10600 DDR3
On Wed, Mar 21, 2012 at 3:31 PM, Kjetil Nygård 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 of the databa
On Fri, Mar 23, 2012 at 10:01 AM, Vick Khera wrote:
> On Wed, Mar 21, 2012 at 3:31 PM, Kjetil Nygård 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 se
On Fri, Mar 23, 2012 at 11:28 AM, Merlin Moncure 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 CentOS) so this is
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 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 transactions
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,
isi
Merlin Moncure writes:
> On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger
> 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. Ask your admin what his throug
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
--
Sent
On Fri, Mar 23, 2012 at 1:57 PM, Tom Lane 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 list (pgsql-gene
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 writes:
On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger 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.
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 it
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 lane
--
Sent via pgsql
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 -> curs
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 exa
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 Even
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,
F
38 matches
Mail list logo
