On 2015-03-25 19:11:06 -0400, Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
Add macros wrapping all usage of gcc's __attribute__.
I noticed that this commit attached pg_attribute_noreturn not only
to the extern declarations, but to some actual function definitions.
Unless either
On 12/21/2014 02:22 PM, Andrew Dunstan wrote:
On 11/15/2014 05:56 PM, Andrew Dunstan wrote:
On 11/13/2014 11:41 AM, Andrew Dunstan wrote:
On 11/13/2014 11:09 AM, Tom Lane wrote:
Andrew Dunstan and...@dunslane.net writes:
I often get annoyed because psql is a bit too aggressive when it
Hello,
At Thu, 26 Mar 2015 18:50:24 +0100, Andres Freund and...@2ndquadrant.com
wrote in 20150326175024.gj...@alap3.anarazel.de
I think the problem here is that the *primary* makes no such
assumptions. Init forks are logged via stuff like
smgrwrite(index-rd_smgr, INIT_FORKNUM,
On Thu, Mar 26, 2015 at 10:44 PM, hitesh ramani hiteshram...@hotmail.com
wrote:
Hello devs,
I'm trying to understand how sorting exactly works in Postgres, I've
understood that there are two sorting mechanisms depending on the size of
the data, one being qsort which is initiated if workmem
Hello devs,
I'm trying to understand how sorting exactly works in Postgres, I've understood
that there are two sorting mechanisms depending on the size of the data, one
being qsort which is initiated if workmem is 1024 kb and the other being
external sort which is initiated in the other case.
On 2015-03-26 15:13:41 +0100, Andres Freund wrote:
On 2015-03-26 13:55:22 +, Thom Brown wrote:
I still, however, have a problem with the separate and original issue of:
# insert into utest (thing) values ('moomoo');
ERROR: index utest_pkey contains unexpected zero page at block 0
On 03/02/2015 12:43 AM, Heikki Linnakangas wrote:
On 02/27/2015 04:19 PM, Anastasia Lubennikova wrote:
I add MemoryContext listCxt to avoid memory leak. listCxt is created once
in gistrescan (only for index-only scan plan ) and reseted when scan of the
leaf page is finished.
I do not sure if
On Mar 26, 2015 4:20 AM, Vladimir Borodin r...@simply.name wrote:
26 марта 2015 г., в 7:32, Michael Paquier michael.paqu...@gmail.com
написал(а):
On Thu, Mar 26, 2015 at 12:23 PM, Venkata Balaji N nag1...@gmail.com
wrote:
Test 1 :
[...]
If the master is crashed or killed abruptly, it
On 27/03/15 09:14, Peter Geoghegan wrote:
On Thu, Mar 26, 2015 at 2:51 PM, Heikki Linnakangas hlinn...@iki.fi wrote:
[...]
Oops - You're right. I find it interesting that this didn't result in
breaking my test cases.
[...]
Reminds of the situation where I got an A++ for a COBOL programming
On 3/25/15 2:00 PM, Andres Freund wrote:
On 2015-03-25 14:50:44 -0400, Tom Lane wrote:
Jim Nasbyjim.na...@bluetreble.com writes:
On 3/24/15 6:26 PM, Tom Lane wrote:
Hm. We're all agreed that there's a use case for exposing PG_VERSION_NUM
to the makefiles, but I did not hear one for
On 3/26/15 12:14 PM, hitesh ramani wrote:
Hello devs,
I'm trying to understand how sorting exactly works in Postgres, I've
understood that there are two sorting mechanisms depending on the size
of the data, one being qsort which is initiated if workmem is 1024 kb
That's incorrect. What
On 03/26/2015 08:00 PM, Peter Geoghegan wrote:
On Wed, Mar 25, 2015 at 12:42 PM, Peter Geoghegan p...@heroku.com wrote:
My next revision will have a more polished version of this scheme. I'm
not going to immediately act on Robert's feedback elsewhere (although
I'd like to), owing to time
On 2014-12-21 14:22:10 -0500, Andrew Dunstan wrote:
@@ -301,11 +301,11 @@ slashUsage(unsigned short int pager)
* show list of available variables (options) from command line
*/
void
-helpVariables(unsigned short int pager)
+helpVariables(unsigned short int pager, int
Bruce,
* Bruce Momjian (br...@momjian.us) wrote:
On Tue, Dec 9, 2014 at 05:38:25PM -0500, Stephen Frost wrote:
My comment that include_realm is supported back to 8.4 was because there
is an expectation that a pg_hba.conf file can be used unchanged across
several major releases. So
On 26 March 2015 at 00:55, Michael Paquier michael.paqu...@gmail.com
wrote:
On Thu, Mar 26, 2015 at 1:02 AM, Fabrízio de Royes Mello
fabriziome...@gmail.com wrote:
On Wed, Mar 25, 2015 at 12:46 PM, Fabrízio de Royes Mello
fabriziome...@gmail.com wrote:
On Wed, Mar 25, 2015 at 10:53
On 2015-03-26 11:27:32 -0400, Tom Lane wrote:
Being the one complaining, I'll go do the legwork to clean this up.
Looks good, Thanks!
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
On 3/25/15 8:35 PM, Jeff Janes wrote:
On Wed, Mar 25, 2015 at 12:45 PM, Jim Nasby jim.na...@bluetreble.com
mailto:jim.na...@bluetreble.com wrote:
I see 3 settings that allow people to accidentally shoot themselves
in the foot; fsync, wal_sync_method and full_page_writes.
How about
On Thu, Mar 26, 2015 at 2:51 PM, Heikki Linnakangas hlinn...@iki.fi wrote:
Attached revision, V3.1, implements this slightly different way of
figuring out if an insertion is speculative, as discussed. We reuse
t_ctid for speculatively inserted tuples. That's where the counter
goes. I think
Hackers;
I spotted this after doing some owner reassignments and then dropping
the old roles.
It looks like using either reassign or alter type owner to, the pg_class
entry stays with old rolID.
Then if we drop that old role going forward pg_dump complains about
invalid owner.
See below test
I've pushed Anastasia's patch to support index-only scans with GiST, and
it's time to add opclasses support for all the opclasses that are not
lossy. I think at least all the btree_gist opclasses need to be
supported, it would be pretty surprising if they didn't support
index-only scans, while
Hi, hackers!
I want to show my proposal idea for GSoC 2015. I'm newbie to coding for
PostgreSQL.
http://www.google-melange.com/gsoc/proposal/public/google/gsoc2015/ivanitskiy_ilya/5629499534213120
***
*Abstract:*
Currently support for microvacuum is implemented only for BTree index. But
GiST
On 03/26/2015 11:10 AM, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
Without having actually tried it, it looks clean enough to me. If
there's more pager options we might at some point introduce a pager
options struct instead adding more options to PageOutput. But for now it
I've read proposal [1] and also major part of thread [2]. [1] encouraged me to
try an alternative approach, which does not require flags at tuple
level. After thinking about it for some time, I decided to code something -
see attachment of this mail. (I was not sure whether I should write some
Folks,
For reasons unclear, dates before the Common Era are disallowed in
make_date(), even though about 2/3 of the underlying data type's range
up until the present time fits that description.
Please find attached a patch fixing same.
Cheers,
David.
--
David Fetter da...@fetter.org
Jerry Sievers gsiever...@comcast.net writes:
Hackers;
I spotted this after doing some owner reassignments and then dropping
the old roles.
It looks like using either reassign or alter type owner to, the pg_class
entry stays with old rolID.
Then if we drop that old role going forward
Svenne == Svenne Krap sve...@krap.dk writes:
Svenne I still need to check against the standard and I will run it
Svenne against a non-trivival production load... hopefully I will
Svenne finish up my review shortly after the weekend...
Thanks for the review so far; any progress? I'm quite
26 марта 2015 г., в 7:32, Michael Paquier michael.paqu...@gmail.com
написал(а):
On Thu, Mar 26, 2015 at 12:23 PM, Venkata Balaji N nag1...@gmail.com wrote:
Test 1 :
[...]
If the master is crashed or killed abruptly, it may not be possible to do a
rewind. Is my understanding correct
On 03/26/2015 11:10 AM, Tom Lane wrote:
Andres Freund and...@2ndquadrant.com writes:
Without having actually tried it, it looks clean enough to me. If
there's more pager options we might at some point introduce a pager
options struct instead adding more options to PageOutput. But for now it
Andres Freund and...@anarazel.de writes:
On 2015-03-25 19:11:06 -0400, Tom Lane wrote:
I think this is a bad idea, because it's going to look like heck after
pgindent gets through with it. Do we actually need decoration on the
function definitions?
Hm, I guess it should not look any worse
Andres Freund and...@2ndquadrant.com writes:
Without having actually tried it, it looks clean enough to me. If
there's more pager options we might at some point introduce a pager
options struct instead adding more options to PageOutput. But for now it
seems ok enough.
My reaction is that now
Jeff Janes jeff.ja...@gmail.com writes:
When building with LOCK_DEBUG but without casserts, I was getting unused
variable warnings.
I believe this is the correct way to silence them.
Committed, thanks.
regards, tom lane
--
Sent via pgsql-hackers mailing list
On 2015-03-26 13:55:22 +, Thom Brown wrote:
I still, however, have a problem with the separate and original issue of:
# insert into utest (thing) values ('moomoo');
ERROR: index utest_pkey contains unexpected zero page at block 0
HINT: Please REINDEX it.
I don't see why the user
32 matches
Mail list logo