in quotes?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
rather write it as separate EXISTS clauses rather
than using UNION, but perhaps others have a different preference...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME
just change it to whatever they want), but I
don't know how many other people have this need. I guess I could at
least put the scripts up on pgFoundry...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
should have an approved API for dumping stats from one database
and loading them into another. pg_dump needs this as well, IMO.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME
of
adding a fixed cost, I think we should multiply by the estimated
number of rows.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
On Aug 11, 2008, at 3:40 PM, Gregory Stark wrote:
Decibel! [EMAIL PROTECTED] writes:
On Aug 8, 2008, at 3:23 PM, Tom Lane wrote:
* has no set operations (UNION etc), grouping, set-returning
functions
in the SELECT list, LIMIT, or a few other funny cases
Couldn't union/union all be treated
before telling all the other backends of the change?
BTW, it would be nice if it would actually remove the old file, but
that sounds like a lot more work...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
On Aug 13, 2008, at 4:12 AM, Magnus Hagander wrote:
Tom Lane wrote:
Decibel! [EMAIL PROTECTED] writes:
I disagree. While we don't guarantee stats are absolutely up-to-
date,
or atomic I don't think that gives license for them to just
magically
not exist sometimes.
Would it really
rows=50 loops=1)
Total runtime: 82598.556 ms
(8 rows)
[EMAIL PROTECTED]
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
On Wed, Aug 13, 2008 at 07:33:40PM +0100, Andrew Gierth wrote:
The following message is a courtesy copy of an article
that has been posted to pgsql.hackers as well.
Decibel! == Decibel! [EMAIL PROTECTED] writes:
Decibel Roughly what I get on my MBP (I'm about a factor of 2
Decibel
On Aug 13, 2008, at 3:52 PM, Decibel! wrote:
The problem is that by looking for a constant row, you're actually
eliminating the entire effect being tested, because the uncorrelated
subselect is run ONCE as an initplan, and the entire query time is
then spent elsewhere. The differences in runtime
fetching only row 1 (which is indeed
physically first).
So the question is: why?? How can it be cheaper to hit 2 buffers than 1?
Though, unless we can improve the speed of seqscanning an entire page
vs pulling the exact row we need it's probably still a moot point.
--
Decibel!, aka Jim C. Nasby
farm for each operating system.
Hmm, that idea sounds remarkably familiar thinks back to a meeting in
NJ about 2 years ago
...and one at Pervasive even before that...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net
(which is actually desirable
for other reasons), but that's an awfully big task that no one's
taken on.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
.
Is the intention for the types to go into pg_catalog? It'd be nice if
you could specify what schema they should be installed in. An
uninstall would also be good.
Thanks for doing this, I've wished we had uint types in the past, and
I'm sure I will again in the future!
--
Decibel!, aka Jim C
a = (b = c), I'd vote that
we just go with =. Anyone trying to do a = b = c should
immediately question if that would work.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME
on the index tuples.
Possibly. I doubt anyone's ever taken a hard look at the cpu_xxx
values.
Josh Berkus indicated at PGCon that he's had luck *decreasing* the
CPU costs, but IIRC that was mostly on OLAP systems. It seems we need
some real data here.
--
Decibel!, aka Jim C. Nasby, Database
changes are a bit less frequent, and views are
probably the least frequent.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
this will be a first. :)
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
/pgsql-hackers
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
*and* can't change their application to
wrap it's use in ().
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
,
while clarifying this stuff would help people immediately... I think
a TODO would be good to make sure this doesn't fall through the cracks.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Is it intentional that dblink's unnamed connections don't get re-used?
stats=# select datname, usename from pg_stat_activity;
datname | usename
-+-
stats | decibel
(1 row)
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select
Sorry for the self-reply...
On Oct 18, 2007, at 9:09 AM, Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-used?
From the dblink docs (both 8.1 and HEAD):
if only one argument is given, the connection is unnamed; only
one unnamed
connection can exist
value under
the impression that it impacted prepared statements.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
---(end of broadcast)---
TIP 6: explain
On Oct 18, 2007, at 11:17 PM, Joe Conway wrote:
Decibel! wrote:
Is it intentional that dblink's unnamed connections don't get re-
used?
yes
stats=# select dblink_connect('dbname=stats');
dblink_connect
OK
(1 row)
stats=# select dblink_connect('dbname=postgres
On Nov 2, 2007, at 11:29 AM, Tom Lane wrote:
[ splorfff... ] The grammar support alone will cost ten times that.
When next we meet, expect me to ask you how that's pronounced. ;)
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy
just do
$blah in embedded SQL statements.
While we're talking about plpgsql... is there a TODO to allow RAISE
to take a variable instead of just a fixed string? Yes, I can always
do RAISE '%', variable, but then I lose % expansion.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL
On Nov 2, 2007, at 10:49 AM, Andrew Dunstan wrote:
update tname set foo = bar ... where foo is null or foo bar ...
FYI, you should be able to do WHERE foo IS DISTINCT FROM bar instead.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy
On Nov 15, 2007, at 4:41 AM, Gregory Stark wrote:
Ask me about EnterpriseDB's Slony Replication support!
Hah, wtf is that all about? :)
BTW, looked at londiste?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net
On Dec 4, 2007, at 4:48 PM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 4 Dec 2007 16:41:52 -0600
Decibel! [EMAIL PROTECTED] wrote:
On Nov 15, 2007, at 4:41 AM, Gregory Stark wrote:
Ask me about EnterpriseDB's Slony Replication support!
Hah, wtf
to the drive. Doing
so allows the drive to optimally order all of the reads.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
if the kernel issued physical IO? I find it
hard to believe that other RDBMSes wouldn't like to have that info...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic
to decide when to do it.
TODO?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
? Also, testing on 64 bit would be interesting.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
in...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
and couldn't find anything significant. Eventhough it shows 4391
physical reads, that's from OS cache, since i ave already run the
query multiple times.
Have you tried just executing the query with executor stats on? You
could be seeing the overhead of explain analyze...
--
Decibel!, aka
, then
restore the saved one.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpKD3eTOJmEA.pgp
Description: PGP signature
against deadlocks...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpEq5RUInVoR.pgp
Description: PGP signature
*requiring* this, but it would certainly be a nice
option to have. Right now there's absolutely no way that you could get
Postgres to use a port 1024.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
asynchronously, since that gives the filesystem, etc a better shot at
re-ordering the reads to improve performance.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpSjafYi0G3G.pgp
Description: PGP signature
than DDL, but still).
The reason I put triggers in quotes is because I'm not suggesting that
we actually put triggers on the catalog tables, since we all know that's
hard/impossible. Instead this would have to tie into command processing,
similar to what you're proposing for truncate.
--
Decibel
to have over 100k rows in a table, and
there's just no way to capture any kind of a real picture of that with
only 10 buckets.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpTmTmwysHI5.pgp
Description: PGP
I had a mail issue on my end which resulted in a number of outbound
emails getting stuck in a queue. They all just went out; sorry for the
flood.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
On Mon, Jan 28, 2008 at 11:14:05PM +, Christopher Browne wrote:
On Dec 6, 2007 6:28 PM, Decibel! [EMAIL PROTECTED] wrote:
FWIW, I've never seen anything but a performance increase or no change
when going from 10 to 100. In most cases there's a noticeable
improvement since it's common
On Mon, Jan 28, 2008 at 09:09:13PM -0300, Alvaro Herrera wrote:
Decibel! wrote:
On Fri, Jan 25, 2008 at 11:40:19AM +, Simon Riggs wrote:
(for 8.4 ...)
I'd like to introduce triggers that fire when we issue a truncate:
Rather than focusing exclusively on TRUNCATE, how about
.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
pgpbkSuadbMUY.pgp
Description: PGP signature
On Thu, Jan 31, 2008 at 11:45:55AM +, Simon Riggs wrote:
On Thu, 2008-01-31 at 10:22 +, Gregory Stark wrote:
Decibel! [EMAIL PROTECTED] writes:
CLUSTER isn't DDL. Most forms of ALTER TABLE are. And CREATE blah, etc.
Fwiw I would call CLUSTER DDL. Note that it does make
problems, not one.
Yes, this problem goes way beyond OOM. Just try and configure
work_memory aggressively on a server that might see 50 database
connections, and do it in such a way that you won't swap. Good luck.
We really do need a way to limit how much memory we will use in total.
--
Decibel
On Tue, Feb 05, 2008 at 01:54:17PM -0800, Ron Mayer wrote:
Decibel! wrote:
Yes, this problem goes way beyond OOM. Just try and configure
work_memory aggressively on a server that might see 50 database
connections, and do it in such a way that you won't swap. Good luck.
That sounds
switch that dumps 2 files,
no ?
Probably also better from a mvcc perspective.
+1
For that matter, it'd be better if you could just get all 3 files (pre,
data, post) in one shot with one transaction; that would guarantee you a
clean dump.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL
?
Sounds possible.
If we build that, it's probably not a far stretch to just allocate
shared memory as a number of smaller segments; that would allow us to
grow as well as shrink.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy
...
+1
BTW, if people want to get anal with the names I think it's fine to
also have options to explicitly name the files, but for normal usage
I'd much rather have a simple option flag that just appends stuff to
--file.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give
On Feb 9, 2008, at 1:08 AM, Tom Lane wrote:
Let's not swat flies with steam hammers.
What the heck is a steam hammer? :P
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME
chance. plplgsql is a strongly typed language, and a construct
like that couldn't have any known-in-advance data type.
Would it be reasonable to teach EXECUTE about NEW and OLD? That
should allow the OP to do what he's looking for...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL
On Feb 14, 2008, at 7:27 AM, Alvaro Herrera wrote:
Attributes: S -- superuser
R -- create role
D -- create database
I -- inherit
Can we add something similar to the bottom of \z?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your
writing everything out.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
. And synchronous reads are only fast if the system
understands what's going on and reads a good chunk of data in at
once. I don't know that that happens.
Perhaps a good short-term measure would be to have recovery allocate
a 16M buffer and read in entire xlog files at once.
--
Decibel!, aka Jim
during
8.3 development; whatever happened to it?
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
with another server. I'm not sure at what stage this
happens (getting results, sending a query, etc). The only way I've found
to clear it is to restart the database the connection was coming from.
Dunno if this is related or not...
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give
build enough
intelligence for the system to understand when the stats follow some
type of pattern (ie: a geometric distribution), and store the stats
differently.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team
with XID size as well. I know there are high-velocity
databases that could use that.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
smime.p7s
Description: S/MIME cryptographic signature
such as sending a MoM message)
I'd like to point out also that AFTER CONNECT is a good opportunity
to CREATE TEMP TABLE (be
nice if a global temp table definition could be persisted and
automatically duplicated into each session, but
never mind).
+1 on both counts. Can we get a TODO?
--
Decibel
and
largest j
in this example--requiring two queries if it was done using the
DISTINCT
ON method.
I don't see how min(record) even allows for that.
I'm not saying that min/avg/max/etc(RECORD) wouldn't be useful; I'm
just failing to see the use in these examples.
--
Decibel!, aka Jim C. Nasby
of
these TODO items completed before the next two releases (unless you
want to
take a stab).
You could also possibly pay a consulting company to implement it, but
even that isn't as easy as it may sound. :)
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer
location you'll trash everything. I
don't know of a good work-around; IIRC we used to leave the archive
command to complete, but that could seriously delay shutdown so it
was changed. I don't think we created an option to control that
behavior.
--
Decibel!, aka Jim C. Nasby, Database Architect
://www.linkedin.com/in/carlosgonzalezcadenas
On Thu, Jan 22, 2009 at 7:16 PM, decibel deci...@decibel.org wrote:
On Jan 22, 2009, at 8:24 AM, Euler Taveira de Oliveira wrote:
No one that I know of. Well, it is a long road. The addition of a
data type
xml is recent (8.3). We lack a set of features
did:
CREATE TABLE a(a_id ...)
CREATE TABLE b(.., a_id int not null, foreign key(id) references a(id))
Handling that would require passing something into
transformColumnNameList() to tell it if it was checking fk_attrs vs
pk_attrs. Perhaps that's overkill... Thoughts?
--
Decibel!, aka Jim C
that there are a lot of databases where
either the whole database fits in cache, or a decent chunk of
relatively small core relations fit in cache and then there are some
big or infrequently-used ones that don't.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your
Thought folks might get a kick out of this since he's referenced all
over our code: http://www.appelbaum.net/
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list
case is even more interesting. Something is
seriously screwy with small seqscans it seems.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers
at the table level) would be handy.
And +1 on reviving newsysviews, but of course I'm biased... ;P
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers
.
Unless they haven't realized that we've been pulling a MySQL and
silently truncating their data. :(
On another point, I agree that compression would be nice, and the way
to fix that is to expose knobs for controlling TOAST thresholds
(something I've wanted forever).
--
Decibel!, aka
the new updatable views, you're still hosed if you add a
column to the table. I see that being a lot more useful than a simple
column alias (you're correct that we'd need to support calculated
ones, which is indeed a lot harder).
--
Decibel!, aka Jim C. Nasby, Database Architect deci
work). But if I knew what the previous
query was, I'd at least have half a chance to know what portion of
the code was responsible, and could then look at the code to see if
the idle state was expected or not.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your
to pay to have it done. :)
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
On May 18, 2009, at 10:25 PM, Tom Lane wrote:
decibel deci...@decibel.org writes:
The gripe I have with \d is that the footnotes are very hard to
scan through once you have more than a few things on a table. What
I'd like to see is a version that provides the same information, but
in a tabular
TABLE wants ...
Hmm what if we made the default to be all-tabular output, but had
a different command that would spit out the SQL to re-create something?
(I agree that the cut-and-paste ability is extremely handy and
wouldn't want to remove it.)
--
Decibel!, aka Jim C. Nasby, Database
On May 19, 2009, at 10:52 AM, Robert Haas wrote:
How 'bout we flip that around? :-)
+1
(BTW, I know there's pg_dump, but being able to get SQL out of psql
is just a lot more convenient)
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain
I'm thinking should go in the function rather than
in the option parsing section. But I didn't want to put any more
effort into this if it's not something we actually want.
patch
Description: Binary data
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer
of a analyze everything command.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
On May 27, 2009, at 11:31 AM, decibel wrote:
It does seem somewhat useful to be able to analyze all databases
easily from the command-line, but putting it into vacuumdb is
certainly a hack.
So... do we want a completely separate analyzedb command? That
seems like far overkill.
Arguably
to present it all as one, I suggest a
union view that turns the machine-understood data into a human-
understandable text format.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers
).
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
of users too (not this exact case, but similar).
Perhaps what we really want is an optimization level GUC so that
users can tell the backend how much overhead they want the optimizer
to spend on trying to work around stupidity... :)
--
Decibel!, aka Jim C. Nasby, Database Architect deci
conceivably be called from other languages, such
as plPerl.
But it sounds like this can be done via an add-on, so no need to add
it directly to the backend.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
be worthwhile to some?
Here's an off-the-wall thought... since most of the CPU time is in
the sort, what about allowing a backend to fork off dedicated sort
processes? Aside from building multiple indexes at once, that
functionality could also be useful in general queries.
--
Decibel!, aka Jim C
size of your data that's being toasted? I actually
have a number of cases where I'd like to push data into external
storage, because it seriously hurts tuple density (and I doubt it'd
compress well).
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some
encoded data.
--
Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
[home_phone, mobile_phone,
work_phone])::text[]))
Which means automatic seqscan. Would it be difficult to teach the
planner to handle this case differently? I know it's probably not
terribly common, but it is very useful.
--
Decibel! [EMAIL PROTECTED] (512) 569-9461
--
Sent via pgsql
On 2/6/12 3:19 PM, Bruce Momjian wrote:
While we're waiting for anyone else to weigh in with an opinion on the
right place to draw the line here, do you want to post an updated
patch with the changes previously discussed?
Well, I think we have to ask not only how many people are using
201 - 293 of 293 matches
Mail list logo