On Fri, Mar 23, 2012 at 18:05, Fujii Masao wrote:
> On Sat, Mar 24, 2012 at 1:49 AM, Robert Haas wrote:
>> On Fri, Mar 23, 2012 at 12:42 PM, Fujii Masao wrote:
>>> On Fri, Mar 23, 2012 at 9:41 PM, Robert Haas wrote:
On Fri, Mar 23, 2012 at 6:13 AM, Fujii Masao wrote:
> On Fri, Mar 23,
On Friday, March 16, 2012 10:40:46 AM Dimitri Fontaine wrote:
> > This will have the effect of calling triggers outside of alphabetic
> > order. I don't think thats a good idea even if one part is ANY and the
> > other a specific command.
> > I don't think there is any reason anymore to separate th
posix_fadvise() is a fallback.
Regards,
Jeff Davis
initdb-fsync-20120325.patch.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Fri, Mar 23, 2012 at 11:11 AM, Alvaro Herrera
wrote:
> Are you going to provide a rebased version?
Rebased version attached, this patch also includes Robert's earlier suggestions.
parallel_pg_dump_5.diff.gz
Description: GNU Zip compressed data
--
Sent via pgsql-hackers mailing list (pgsql-
Jim Nasby writes:
> On 3/22/12 2:13 PM, Stephen Frost wrote:
>> Has anyone been working on or considering how to improve the logic
>> around doing extends on relations to perhaps make larger extensions
>> for larger tables? Or make larger extensions when tables are growing
>> very quickly?
> I k
On 3/22/12 2:13 PM, Stephen Frost wrote:
Greetings,
I've recently become a bit annoyed and frustrated looking at this in
top:
23296 postgres 20 0 3341m 304m 299m S 12 0.9 1:50.02 postgres: sfrost
gis [local] COPY waiting
24362 postgres 20 0 3353m 298m 285m D 12 0.9 1:24.9
On 3/23/12 7:38 AM, Robert Haas wrote:
And here are the latency results for 95th-100th percentile with
checkpoint_timeout=16min.
ckpt.master.13: 1703, 1830, 2166, 17953, 192434, 43946669
ckpt.master.14: 1728, 1858, 2169, 15596, 187943, 9619191
ckpt.master.15: 1700, 1835, 2189, 22181, 206445, 821
On 3/23/12 1:58 PM, Dave Cramer wrote:
> Someone has approached the JDBC list to do some work on the driver as
> a GSOC project.
>
> I need to know what is involved in mentoring and how to get the
> project approved
I've approved you as a mentor. I suggest also joining the
pgsql-students mailing
lekon wrote:
> i want see the log of INSERT, SELECT, DELETE... within postgresql
> v9.1.3
The pgsql-hackers list is for discussions about development of the
PostgreSQL datatbase system; discussions about how to use it should
go to another list. The particular question would be appropriate for
On Friday, March 23, 2012 04:32:02 PM Dimitri Fontaine wrote:
> I would like to get back on code level review now if at all possible,
> and I would integrate your suggestions here into the next patch revision
> if another one is needed.
Ok, I will give it another go.
Btw I just wanted to alert you
On Sun, Mar 25, 2012 at 18:59, Tom Lane wrote:
> Andrew Dunstan writes:
>> Every so often buildfarm animals (nightjar and raven recently, for
>> example) report failures on starting up the postmaster. It appears that
>> these failures are due to the postmaster not creating the pid file
>> within
Andrew Dunstan writes:
> Every so often buildfarm animals (nightjar and raven recently, for
> example) report failures on starting up the postmaster. It appears that
> these failures are due to the postmaster not creating the pid file
> within 5 seconds, and so the logic in commit
> 0bae3bc9be
Thanks.. I'll keep those issues in mind.
On Sat, Mar 24, 2012 at 6:18 PM, Tatsuo Ishii wrote:
> >> Well, you'd have to start by demonstrating the benefit of it. The
> >> advantage of query caches in proxies and clients is well-known, because
> you
> >> can offload some of the work of the datab
Every so often buildfarm animals (nightjar and raven recently, for
example) report failures on starting up the postmaster. It appears that
these failures are due to the postmaster not creating the pid file
within 5 seconds, and so the logic in commit
0bae3bc9be4a025df089f0a0c2f547fa538a97bc k
Robert Haas writes:
> The bit about maybe not getting both t and f as MCVs on a Boolean does
> seem a little worrying, but I'm not sure whether it actually affects
> query planning in a materially negative way. Can you demonstrate a
> case where it matters?
If we were trying to force that to hap
On Sun, Mar 25, 2012 at 6:11 AM, Marc Mamin wrote:
> Hello,
>
> Here is something we'd like to have:
>
> http://archives.postgresql.org/pgsql-hackers/2012-01/msg00650.php
>
> As we are quite busy and this issue hasn't a high priority, we haven't
> followed it until now :-(
>
> I'm only a Postgres
On Sat, Mar 24, 2012 at 12:17 AM, Dan McGee wrote:
> This is a bit of a corner case in all honesty, but if you have a short
> table (under 20 rows), the 10% heuristic used that decides whether
> distinct values scale with the row count will result in rather odd
> values for stadistinct in pg_stati
On Sun, Mar 25, 2012 at 7:14 AM, Constantin Teodorescu
wrote:
> "This paper analyzes the scalability of seven system applications (Exim,
> memcached, Apache, PostgreSQL, gmake, Psearchy, and MapReduce) running on
> Linux on a 48-core computer. Except for gmake, all applications
> trigger scalabili
Hello all ... again !
SHORT INTRODUCTION
===
Remember me? A couple of years ago (maybe 10) I created the PgAccess
package for managing PostgreSQL!
Since than I have done many things, all of them related to PostgreSQL, of
course!
Our company is managing the National Animal Tracking
This is a bit of a corner case in all honesty, but if you have a short
table (under 20 rows), the 10% heuristic used that decides whether
distinct values scale with the row count will result in rather odd
values for stadistinct in pg_statistic, such as '-0.2' or '-0.67',
rather than the expecte
Someone has approached the JDBC list to do some work on the driver as
a GSOC project.
I need to know what is involved in mentoring and how to get the
project approved
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgr
Hi,
while working on a support case I stumbled upon a bug in pg_upgrade.
Upgrade fails with "No such file or directory" when a database is
moved to a non-default tablespace and contains a table that is moved
to pg_default. The cause seems to be that the following test
incorrectly equates empty spc
Hi,
[...]
> > Placing a sync (i.e., the strongest Power barrier) accordingly would,
> > however,
> > still be insufficient for the second problem, as it would only fix the
> > reordering of read-read pairs by Worker 1 and the store atomicity issue from
> > Worker 0. But the writes on Worker 0 cou
i want see the log of INSERT, SELECT, DELETE... within postgresql v9.1.3
i'm so sorry, my english level...
how can i see that.
transaction log?... or other thing...?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-can-i-see-the-log-tp5583083p5583083.html
Sent fro
On 20 mar 2012, at 13.08, Heikki Linnakangas wrote:
> On 20.03.2012 11:10, Claes Jakobsson wrote:
>>
>> Personally I'd love a type 2 JDBC driver for PostgreSQL.
>
> Why?
listen/notify over SSL for example unless that's been fixed in the JDBC driver
recently. And I'm sure there are other things
Il giorno mar, 20/03/2012 alle 11.16 +, Peter Geoghegan ha scritto:
> On 20 March 2012 10:53, Marco Nenciarini
> wrote:
> > alert.c: In function ‘dbms_alert_defered_signal’:
> > alert.c:839:33: error: dereferencing pointer to incomplete type
> > make: *** [alert.o] Error 1
> >
> > I've also tr
On 19 mar 2012, at 22.45, Merlin Moncure wrote:
> one pl/java based project that IMO is just screaming to be done is a
> pl/java based FDW (wrapping JDBC) that would approximately reproduce
> dblink...maybe with some extra features geared towards ETL type jobs
> like a row based callback for transf
Hello,
Here is something we'd like to have:
http://archives.postgresql.org/pgsql-hackers/2012-01/msg00650.php
As we are quite busy and this issue hasn't a high priority, we haven't followed
it until now :-(
I'm only a Postgres user, not a hacker, so I don't have the knowledge to he
On Sat, Mar 17, 2012 at 10:45 PM, Alvaro Herrera
wrote:
> Here is v11. This version is mainly updated to add pg_upgrade support,
> as discussed. It also contains the README file that was posted earlier
> (plus wording fixes per Bruce), a couple of bug fixes, and some comment
> updates.
The mai
29 matches
Mail list logo
