Re: [HACKERS] Transaction Snapshots and Hot Standby

immediately as WAL reply can recommence which seems like a better deal than a bloated database. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Transaction Snapshots and Hot Standby

which starts up uses that. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Synchronous Log Shipping Replication

Tom Lane [EMAIL PROTECTED] writes: I'm not sure what to do if we need signals sent from processes that aren't connected to shared memory; but maybe we need not cross that bridge here. Such as signals coming from the postmaster? Isn't that where most of them come from though? -- Gregory

Re: [HACKERS] Our CLUSTER implementation is pessimal

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Yeah, I've been thinking about how to use the planner to do this. I thought the answer to that was going to be more or less call cost_sort() and cost_index() and compare the answers. That was the way I was headed

Re: [HACKERS] Our CLUSTER implementation is pessimal

and just the columns excluding the header and pass that to the heap rewrite module. Passing the header separately. Heap rewrite would have to call HTSV on just the header (with the same hack I put in for this patch to allow passing InvalidBuffer to HTSV). -- Gregory Stark EnterpriseDB

Re: [HACKERS] [PATCH] Cleanup of GUC units code

be. * in the longer term, we look for the solution to be a config checker I don't think a config checker directly addresses the same problem. I never set work_mem in a config and it still annoys the hell out of me. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] [PATCH] Cleanup of GUC units code

, if not there already? It is, I paraphrased it on my original message as: HINT: It's perfectly clear what you want but I'm going to refuse to do it until you type it exactly as I say: GB -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask

Re: [HACKERS] [PATCH] Cleanup of GUC units code

?! -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [PATCH] Cleanup of GUC units code

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Alvaro Herrera [EMAIL PROTECTED] writes: It's good as a joke, but what if the user says '1024b'? Does it mean 1024 blocks or one kilobyte? If blocks, what size are we talking, the usual 512 bytes, or our BLCKSZ

Re: [HACKERS] Common Table Expressions (WITH RECURSIVE) patch

read. If it does, read on to see what it does with them. The main reason to define them appeared to be to use them to say that supporting mutual recursion is not required. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support

Re: [HACKERS] Prototype: In-place upgrade v02

of relations is required because of that. Neither will the FSM rewrite. Not sure about DSM yet. And just to confirm -- they don't change the name of the files the postmaster expects to find in its data directory, right? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] About that CommitFest redirect page ...

open commitfest which makes it clear when to use which. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Proposed patch: make pg_dump --data-only consider FK constraints

to indicate how to do that with Postgres. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Page layout footprint

to find some counter-example) Doesn't really change the argument though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Patch: propose to include 3 new functions into intarray and intagg

a feeling others might feel differently. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Patch: propose to include 3 new functions into intarray and intagg

Markus Wanner [EMAIL PROTECTED] writes: Hi, Gregory Stark wrote: Regarding the patch listed on the commitfest 3 new functions into intarray and intagg (which I just noticed has a reviewer listed -- doh): ..well, just add your name as well, no? Yeah, people should feel free to comment

Re: [HACKERS] code coverage patch

to disk, no coverage of mark/restore on index scans... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Question regarding the database page layout.

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: BTW, there are at least two copies of that code to be changed. I'd suggest grepping for assignments to t_hoff to be sure there aren't more. I did send in a patch a while ago to get

Re: [HACKERS] [PATCH] Cleanup of GUC units code

thing is insane. Because you think some user will be trying to specify their shared_buffers in bits? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] [PATCH] Cleanup of GUC units code

blocks, for example. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Question regarding the database page layout.

the goal was to save space by aligning the tuples on the page more densely. That seems to me to be more fruitful as about half the tuples will save four bytes even on tables with small or missing null bitmaps. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] Question regarding the database page layout.

-align case. +1 -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] WIP patch: Collation support

with representing glyphs in UTF32 before they gave up on that. Does anyone still use composable characters? Note that we don't currently support composable characters at all. I'm not sure if that's a nobody really cares issue or a bug we should aim to fix with real collation support. -- Gregory Stark

Re: [HACKERS] Question regarding the database page layout.

Ryan Bradetich [EMAIL PROTECTED] writes: Hello Greg, On Tue, Sep 2, 2008 at 8:30 AM, Gregory Stark [EMAIL PROTECTED] wrote: But I'm confused. You seem to be tweaking the alignment of the data inside the tuple? After the tuple header? I thought we had only one byte of wasted space

Re: [HACKERS] Index scan troubles

comparisons case for which you need a funny header ScanKey. See the comments in access/skey.h, search for row comparisons. I'm not sure if there's a function to create this for you or if you have to do it yourself. Search for other places where SK_ROW_HEADER appears. -- Gregory Stark EnterpriseDB

Re: [HACKERS] Question regarding the database page layout.

Tom Lane [EMAIL PROTECTED] writes: BTW, there are at least two copies of that code to be changed. I'd suggest grepping for assignments to t_hoff to be sure there aren't more. I did send in a patch a while ago to get rid of the old HeapFormTuple() and friends. -- Gregory Stark

Re: [HACKERS] Window functions patch v04 for the September commit fest

:( -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Our CLUSTER implementation is pessimal

forward, bool *should_free); extern bool tuplesort_getdatum(Tuplesortstate *state, bool forward, -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Attaching error cursor position to invalid constant values

or how many lines are in it but that seems unnecessarily baroque. It doesn't seem outrageously chatty to me. Better to err on the side of being too helpful to the user than not helpful enough. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's

Re: [HACKERS] Attaching error cursor position to invalid constant values

would have to deduce which constant is in error based on the type it describes. That could be quite a bit more complex than this example. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training

Re: [HACKERS] Proposal: new border setting in psql

keeping two variants at all really. Why not just make psql's native table formatting exactly ReST? Is there any part of it that we don't like as much as our existing tables? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about

Re: [HACKERS] New FSM allocation policy

if there's enough free space else take left branch). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] code coverage patch

don't use CFLAGS. Shared object link rules should use another variable (LDFLAGS?) and those options should be added that variable as well. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training

Re: [HACKERS] September Commit Fest coming soon!

a committer is actually looking to commit the code he'll want to be sure he has the most recent snapshot including any later changes that might not have warranted an email. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via

Re: [HACKERS] IN, BETWEEN, spec compliance, and odd operator names

to evaluate costs until well after this point. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Implementing cost limit/delays for insert/delete/update/select

. And there are degenerate cases where a single ExecProcNode could do a lot of i/o such as a large scan looking for a single matching record. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via

Re: [HACKERS] Implementing cost limit/delays for insert/delete/update/select

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: You would have to test for whether it's time to sleep much more often. Possibly before every ExecProcNode call would be enough. That would have overhead comparable to EXPLAIN ANALYZE, which is a lot. I don't think

Re: [HACKERS] Extending error-location reports deeper into the system

whether to include the line number. Are you sure there aren't any? Are you sure there isn't anywhere else lurking that expects equal to really mean equal? Perhaps someplace that builds a list and expects to eliminate duplicates? -- Gregory Stark EnterpriseDB http

Re: [HACKERS] proposal sql: labeled function params

for those users? At any point in this discussion has anyone explained why these labels would actually be a good idea? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] Is mdextend really safe?

. Is that true? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] Volatile functions in subqueries don't prevent subqueries from being evaluated in initplans?

Scan on x (cost=0.00..64.80 rows=3480 width=4) (4 rows) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Patch: plan invalidation vs stored procedures

trolling :) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] any psql static binary for iphone ?

I haven't looked at it but there's this: http://www.postgresql.org/about/news.988 -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] SeqScan costs

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: On Tue, 2008-08-12 at 15:46 -0400, Tom Lane wrote: This is only going to matter for a table of 1 block (or at least very few blocks), and for such a table it's highly likely that it's in RAM anyway. So I'm

Re: [HACKERS] Overhauling GUCS

overly-complex solutions trying to solve all these incidental issues which never go anywhere instead of simple solutions which directly tackle the main problem. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via

Re: [HACKERS] Overhauling GUCS

don't have shell access. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] proposal sql: labeled function params

there are huge downsides and no significant up-sides to having this trivial little bit of syntactic sugar. To say nothing that using = or anything like that would be just completely un-SQLish. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about

Re: [HACKERS] gsoc, oprrest function for text search take 2

then the DatumGetTextP and DatumGetTextPP will just be noops anyways. If you store packed data (from DatumGetTextPP) then it's probably safer to store it as Datums so if you need to pass it to any functions which don't expect packed data they'll untoast it. -- Gregory Stark EnterpriseDB

Re: [HACKERS] Join Removal/ Vertical Partitioning

there about join removal, posted about 12 hours later than my original post. Seems to validate the theory anyway. Our posts have a wider audience than may be apparent :-) Well turnabout's fair play... what's the URL? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained

Re: [HACKERS] Replay attack of query cancel

. Or we could just bump the protocol version. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] SeqScan costs

200 but it's not entirely free. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] psql bug -- using old variables and database connection

) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] SeqScan costs

on a moderate sized raid array. But of course when a some of the data is cached the effective random_page_cost is much much lower than that. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Question regarding the database page layout.

to put it so it ends up at right alignment. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Proposal: PageLayout footprint

but footprint should protect people to shot himself. My version of GCC doesn't have that option, what does it do? If structure members aren't in the order they're defined and padded to the alignment they're declared to have in pg_type then Postgres catalogs won't work anyways. -- Gregory Stark

[HACKERS] Skimming icc warnings on mongoose

of unsigned integer with zero Assert(plen = 0 plen mlen); -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] IN vs EXISTS equivalence

by what you mean here. Can you give an example? The usual transformation to consider with UNION is to transform SELECT ... WHERE x OR y into SELECT ... WHERE x UNION ALL SELECT ... WHERE y AND NOT x (modulo handling NULLs properly) -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Visibility Groups

people to hack up their pg_dump or replication script though which might be awkward. Perhaps the way to do that would be to preemptively take locks on all the objects that you'll need, then have a command to indicate you won't need any further objects beyond those. -- Gregory Stark

Re: [HACKERS] Visibility Groups

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Visibility Groups

Gregory Stark [EMAIL PROTECTED] writes: I think Simon's interface was overly complex but if we can simplify it then it could be useful. As Grittner mentioned implicit queries could make use of it automatically. Also pg_dump or Slony could make use of it automatically. Sorry implicit

Re: [HACKERS] Visibility Groups

Alvaro Herrera [EMAIL PROTECTED] writes: Gregory Stark wrote: I think Simon's interface was overly complex but if we can simplify it then it could be useful. As Grittner mentioned implicit queries could make use of it automatically. Also pg_dump or Slony could make use of it automatically

Re: [HACKERS] patch: Add columns via CREATE OR REPLACE VIEW

a AS (select 1 as b, 2 as c, 'three as a); SELECT * FROM b; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] searching bison guru - grouping sets implementation

://article.gmane.org/gmane.comp.db.postgresql.devel.general/83563/match=rollup Tom pointed out that there's more than one way to skin a cat: http://thread.gmane.org/gmane.comp.db.postgresql.devel.cvs/22326/focus=83563 (Oh look at that, he actually used precisely that phrase) -- Gregory Stark EnterpriseDB

Re: [HACKERS] searching bison guru - grouping sets implementation

at that, he actually used precisely that phrase) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Status of DISTINCT-by-hashing work

executor infrastructure look like? Would it have anything in common with the OLAP window functions infrastructure? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers

Re: [HACKERS] DROP DATABASE always seeing database in use

Russell Smith [EMAIL PROTECTED] writes: Gregory Stark wrote: It seems there's something wrong with CheckOtherDBBackends() but I haven't exactly figured out what. There are no other sessions but drop database keeps saying regression is being accessed by other users. I do see Autovacuum

Re: [HACKERS] Mini improvement: statement_cost_limit

not recommended as a global configuration. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] DROP DATABASE always seeing database in use

:45.620115+01 | 2008-08-04 11:45:19.827702+01 | | -1 (1 row) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] DROP DATABASE always seeing database in use

Michael Fuhr [EMAIL PROTECTED] writes: On Mon, Aug 04, 2008 at 11:51:35AM +0100, Gregory Stark wrote: It seems there's something wrong with CheckOtherDBBackends() but I haven't exactly figured out what. There are no other sessions but drop database keeps saying regression is being accessed

Re: [HACKERS] DROP DATABASE always seeing database in use

solved it so this is academic but, the buildfarm runs make installcheck? I thought it just ran make check -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Mini improvement: statement_cost_limit

if we implemented my previous thought of having some settings which generate warnings if they're set at startup saying that's not recommended. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers

Re: [HACKERS] Parsing of pg_hba.conf and authentication inconsistencies

the old ones. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Parsing of pg_hba.conf and authentication inconsistencies

whether the method is supported which is called when the file is parsed. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Fixing the representation of ORDER BY/GROUP BY/DISTINCT

in the hash along with the resulting tuple and replace the resulting tuple iff the new sort key is less than the old sort key. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Fixing the representation of ORDER BY/GROUP BY/DISTINCT

('' op), or 0 */ boolnulls_first;/* do NULLs come before normal values? */ } SortGroupClause; So ASC/DESC is represented by using for sortop? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning

[HACKERS] Messed up CVS status of two ECPG files

delete them. U src/interfaces/ecpg/preproc/keywords.c U src/interfaces/ecpg/test/expected/connect-test1.c -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Messed up CVS status of two ECPG files

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: These two files seem to be getting updated every time I do a CVS update. Doesn't happen here --- maybe something odd in your local CVS state? Huh, indeed. I needed rsync --delete. I'm surprised it hasn't caused any

Re: [HACKERS] Type Categories for User-Defined Types

, but not because we wouldn't want to create new ones. Just because there isn't really any other meta data we want to store about type categories. Aside from the preferred type and the members there isn't anything more to say about them. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Should creating a new base type require superuser status?

to create a preferred type? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Should creating a new base type require superuser status?

new semantics. Unless you're going to allow them to create new C functions, I'm not clear on how much they're going to be able to change the semantics. Well there's plenty that can be done just using text or bytea as representations. citext, or uuid for example. -- Gregory Stark

Re: [HACKERS] [WIP] patch - Collation at database level

ordering operation. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Python 2.5 vs the buildfarm

it was released. But if you're happy doing the work I can't see any reason to stop you either. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] WITH RECUSIVE patches 0723

queries. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] WITH RECUSIVE patches 0723

that this is more common than the converse. I think if we have a choice between always materializing and always inlining then always materializing is much better. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via

Re: [HACKERS] [RFC] Unsigned integer support.

rules). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Research/Implementation of Nested Loop Join optimization

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Manoel Henrique [EMAIL PROTECTED] writes: Yes, I'm relying on the assumption that backwards scan has the same cost as forward scan, why shouldn't it? Because hard drives only spin one direction Good joke

Re: [HACKERS] [RFC] Unsigned integer support.

be a pretty massive semantics change. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] [RFC] Unsigned integer support.

explicit type casts. STATEMENT: select '100' + '100'; Perhaps we could kill two birds with one stone... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Research/Implementation of Nested Loop Join optimization

Manoel Henrique [EMAIL PROTECTED] writes: Yes, I'm relying on the assumption that backwards scan has the same cost as forward scan, why shouldn't it? Because hard drives only spin one direction -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] Adding WHERE clause to pg_dump

seems like the right option to me. The tricky bit would be how to deal with cases where you want a different where clause for different tables. But even if it doesn't handle all cases that doesn't mean a partial solution is unreasonable. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] overlaps performance

might still be lower. I think the reason we don't (aside from it not being at all useful in he past) is that it would lead to a lot of possible index scans being considered. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication

Re: [HACKERS] Do we really want to migrate plproxy and citext into PG core distribution?

by offloading development outside of core but provide users with a perceived complete system. For perl this is important because they want programmers to be able to assume certain modules are present. For postgres the case is less compelling since there isn't an interoperability issue. -- Gregory

Re: [HACKERS] Do we really want to migrate plproxy and citext into PG core distribution?

Dave Page [EMAIL PROTECTED] writes: On Tue, Jul 22, 2008 at 2:39 PM, Gregory Stark [EMAIL PROTECTED] wrote: Tom Lane [EMAIL PROTECTED] writes: From a project-management point of view, it's insanity to set a presumption that pgfoundry is just a proving ground for code that should eventually

Re: [HACKERS] overlaps performance

Grzegorz Jaśkiewicz [EMAIL PROTECTED] writes: So my question would be, why isn't postgresql using indexes for OVERLAPS, and why optimizer doesn't substitute it with something like: (c = a AND d a) OR ( c = a AND c b) How would you use an index for that? -- Gregory Stark EnterpriseDB

Re: [HACKERS] [PATCH]-hash index improving

. The extra work on insert time is O(nlogn) amortized, but I'm not sure good amortized performance is good enough for Postgres. Users are unhappy when they're average performance is good but 1/1000 inserts thrashes their i/o rewriting the whole index... -- Gregory Stark EnterpriseDB http

Re: [HACKERS] [PATCH]-hash index improving

Heikki Linnakangas [EMAIL PROTECTED] writes: Gregory Stark wrote: For i/o-bound databases with very large indexes there should be an opportunity where btree lookups are O(logn) and hash lookups can in theory be O(1). Ignoring the big-O complexity, if a hash index only stores a 32-bit hash

Re: [HACKERS] Postgres-R: primary key patches

to the server that really, it only needs any UNIQUE NOT NULL combination of columns to match. Once the server has any such combination which matches it can skip checking the rest. I can't think of any way to write such a query in SQL. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

vacuum's work-load. What we're doing now is kind of backwards. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] [PATCHES] VACUUM Improvements - WIP Patch

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: I like the idea of only having to do a single pass through the table though. Well, that argument was already overstated: we're not re-reading all of the table now. Just the pages containing dead line pointers

Re: [HACKERS] Fwd: Proposal - UUID data type

? SMTP? NTP? It tends to be important for network protocols since there's no gain in having non-interoperable protocols. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers

<    1   2   3   4   5   6   7   8   9   10   >