There is a problem trying to make Postgres do these things in Parallel.
The backend code isn't thread-safe, so doing a multi-thread
implementation requires quite a bit of work.
Using multiple processes has its own problems: The whole way locking
works equates one process with one
On Mon, 2008-10-20 at 18:45 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2008-10-20 at 17:44 -0300, Alvaro Herrera wrote:
That's been extended with an epoch counter per the docs; I don't think
that's appropriate for the new functions, is it?
I assumed it was, so
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Oct 20, 2008 at 05:49:04PM -0300, Alvaro Herrera wrote:
Hi,
My Debian system (now running Linux 2.6.26) is no longer dumping core
files, and I can't figure out why :-(
Tested now with 2.6.25-2. Coredumps still work there. I submitted it
* pg_last_recovered_xact_xid()
Will throw an ERROR if *not* executed in recovery mode.
returns bigint
* pg_last_completed_xact_xid()
Will throw an ERROR *if* executed in recovery mode.
returns bigint
Should these return xid?
And shouldn't these two be folded together ?
It seems
Robert Haas wrote:
How can you make that the default? Won't it immediately break every
installation without certificates?
*all* SSL installations have certificate on the server side. You cannot
run without it.
s/without certificates/with self-signed certificates/
which I would guess to be a
Magnus Hagander wrote:
Robert Haas wrote:
How can you make that the default? Won't it immediately break every
installation without certificates?
*all* SSL installations have certificate on the server side. You cannot
run without it.
s/without certificates/with self-signed certificates/
On 21 okt 2008, at 10.04, Peter Eisentraut [EMAIL PROTECTED] wrote:
Magnus Hagander wrote:
Robert Haas wrote:
How can you make that the default? Won't it immediately break
every
installation without certificates?
*all* SSL installations have certificate on the server side. You
cannot
Then they may as well not have bothered with generating a key in the
first place since an attacker can generate one of his own just as
easily...
Actually that's not entirely true. A non-authenticated connection
still protects against passive attacks like sniffers. But active
attacks are
Dear postgresql hackers,
I would like to be able to get results from SQL commands directly in a
binary format, instead of a textual one. Actually, I want to be able to
get timestamps with their full precision (microsecond).
googling around i found some threads on this mailing list about this:
On Tue, Oct 21, 2008 at 11:02:11AM +0300, Peter Eisentraut wrote:
If you install a new web browser, would you want it to be configured by
default to warn about untrusted certificates or to not bother the user
about it? It's pretty much the same question here.
We don't bother users when
I started to rework the SE-PostgreSQL documentation to catch up
the latest implementation, because the existing PDF documents are
a bit legacy to be updated.
In addition, I moved them to wiki site for easier future updates.
http://code.google.com/p/sepgsql/wiki/TheSepgsqlDocument
However, I
On Tue, Oct 21, 2008 at 10:21:38AM +0200, Matthieu Imbert wrote:
I would like to be able to get results from SQL commands directly in a
binary format, instead of a textual one. Actually, I want to be able to
get timestamps with their full precision (microsecond).
Are you sure you cannot get
I guess we'd use the same technique for GIN. ginInsertValue() ??
Hmm, you release the lock at line 412, ginbtree.c before you get the
parent lock at line 428. That seems different to the LY interactions.
Am I looking in the wrong place?
at line 412 new page (right page) is unlocked, old page
(Mike, it lacks a copyright notice, I take it BSD is okay).
Thats fine with me..
Also - for completeness (for the list) - I think the plan is to convert the
awk to perl (via a2p + some tweaking) if awk is not already used as part of
the build process (to avoid adding another prerequisite..)
2008/10/21 KaiGai Kohei [EMAIL PROTECTED]:
Is it possiblt to host it on the wiki.postgresql.org?
If possible, I want to continue it at:
http://wiki.postgresql.org/wiki/SEPostgreSQL
Though I don't know if this is official way, I found that you can
register a new account on
On Tue, 2008-10-21 at 14:11 +0400, Teodor Sigaev wrote:
I guess we'd use the same technique for GIN. ginInsertValue() ??
Hmm, you release the lock at line 412, ginbtree.c before you get the
parent lock at line 428. That seems different to the LY interactions.
Am I looking in the wrong
Martijn van Oosterhout [EMAIL PROTECTED] writes:
You seem to be making the assertion that making an encrypted connection
to an untrusted server is worse than making a plaintext connection to
an untrusted server, which seems bogus to me.
Hm, is it? If you use good old traditional telnet you
Hitoshi Harada wrote:
2008/10/21 KaiGai Kohei [EMAIL PROTECTED]:
Is it possiblt to host it on the wiki.postgresql.org?
If possible, I want to continue it at:
http://wiki.postgresql.org/wiki/SEPostgreSQL
Though I don't know if this is official way, I found that you can
register a new
On Tue, Oct 21, 2008 at 11:55:32AM +0100, Gregory Stark wrote:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
You seem to be making the assertion that making an encrypted connection
to an untrusted server is worse than making a plaintext connection to
an untrusted server, which seems
On 21 okt 2008, at 13.12, Martijn van Oosterhout [EMAIL PROTECTED]
wrote:
On Tue, Oct 21, 2008 at 11:55:32AM +0100, Gregory Stark wrote:
Martijn van Oosterhout [EMAIL PROTECTED] writes:
You seem to be making the assertion that making an encrypted
connection
to an untrusted server is worse
Michael Meskes wrote:
On Tue, Oct 21, 2008 at 10:21:38AM +0200, Matthieu Imbert wrote:
I would like to be able to get results from SQL commands directly in a
binary format, instead of a textual one. Actually, I want to be able to
get timestamps with their full precision (microsecond).
Are
Hi,
I'm new to Postgres and would appreciate some help
in understanding what the limitations of TSEARCH2 and
the Thesauri operation.
I'm trying to use the thesaurus as a geo-tagger/coder.
The first part of the problem is to create placename
list with additional information such as state,
I need to repair the old version of Postgresql.
pg_dump does not work, I tried few other things but could not come up
with any workable scenario.
Any help will be greatly appreciated!
Thanks,
Michael.
cdb=# vacuum;
WARNING: Rel pg_proc: TID 31/20: OID IS INVALID. TUPGONE 0.
VACUUM
Stefan Kaltenbrunner wrote:
Hitoshi Harada wrote:
2008/10/21 KaiGai Kohei [EMAIL PROTECTED]:
Is it possiblt to host it on the wiki.postgresql.org?
If possible, I want to continue it at:
http://wiki.postgresql.org/wiki/SEPostgreSQL
Though I don't know if this is official way, I found that
Martijn van Oosterhout wrote:
SSH is a good example, it only works with self-signed certificates, and
relies on the client to check it. Libpq provides a mechanism for the
client to verify the server's certificate, and that is safe even if it
is self-signed.
If the client knows the certificate
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2008-10-20 at 18:45 -0400, Tom Lane wrote:
In any case, do not use the wrong return type for the definition you're
implementing.
err...Why would anyone do that?
That's what I wanted to know ;-). If these functions are really going
to return
Hi,
I'm new to Postgres and would appreciate some help
in understanding what the limitations of TSEARCH2 and
the Thesauri operation.
I'm trying to use the thesaurus as a geo-tagger/coder.
The first part of the problem is to create placename
list with additional information such as state,
Mike Aubury [EMAIL PROTECTED] writes:
Also - for completeness (for the list) - I think the plan is to convert the
awk to perl (via a2p + some tweaking) if awk is not already used as part of
the build process (to avoid adding another prerequisite..)
Hmm. I believe the current state of play
On 21 okt 2008, at 13.41, Peter Eisentraut [EMAIL PROTECTED] wrote:
Martijn van Oosterhout wrote:
SSH is a good example, it only works with self-signed certificates,
and
relies on the client to check it. Libpq provides a mechanism for the
client to verify the server's certificate, and
Martijn van Oosterhout [EMAIL PROTECTED] writes:
SSH is a good example, it only works with self-signed certificates, and
relies on the client to check it. Libpq provides a mechanism for the
client to verify the server's certificate, and that is safe even if it
is self-signed.
Sort of. SSH
Gregory Stark [EMAIL PROTECTED] writes:
Sort of. SSH requires you to install the certificate of the server locally
before connecting. If you don't it pops up a big warning and asks if you want
to install it. On subsequent connections it looks up the key for the name of
the host you're trying
On Oct 17, 2008, at 4:30 AM, Vladimir Sitnikov wrote:
Decibel! [EMAIL PROTECTED] wrote:
I had tried to use a normal table for store stats information,
but several acrobatic hacks are needed to keep performance.
I guess it is not really required to synchronize the stats into
some physical
Perl code thats readable and maintainable ;-)
In reality - it doesn't look too disimilar from the awk original. I didn't
appreciate that we'd probably need to keep 2 versions (one for unix and one
for windows). In that case - I'd argue that we only need to maintain one
and regenerate the
ITAGAKI Takahiro [EMAIL PROTECTED] writes:
Now I'm working on storing statistics into disks on server
shutdown. If it is impossible unless the module is in core,
I would change my policy...
I'm really not happy with a proposal to put such a feature in core.
Once it's in core we'll have pretty
On 21 okt 2008, at 13.41, Peter Eisentraut [EMAIL PROTECTED] wrote:
Martijn van Oosterhout wrote:
SSH is a good example, it only works with self-signed certificates,
and
relies on the client to check it. Libpq provides a mechanism for the
client to verify the server's certificate, and
Mike Aubury [EMAIL PROTECTED] writes:
In reality - it doesn't look too disimilar from the awk original. I didn't
appreciate that we'd probably need to keep 2 versions (one for unix and one
for windows). In that case - I'd argue that we only need to maintain one
and regenerate the other when
On 20 okt 2008, at 16.51, Andrew Dunstan [EMAIL PROTECTED] wrote:
Magnus Hagander wrote:
Andrew Dunstan wrote:
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
OK. Where would be a good place to put the code? Maybe a new file
src/backend/utils/adt/trigger_utils.c ?
I
On Tue, Oct 21, 2008 at 08:47:35AM -0400, Tom Lane wrote:
Um, IIRC what it's checking there is the server's key signature, which
has nada to do with certificates.
That depends on whether you used an X.509 certificate to authenticate
the original signature. Just about nobody does, but AIUI,
On Tue, Oct 21, 2008 at 03:34:04PM +0200, Magnus Hagander wrote:
On 20 okt 2008, at 16.51, Andrew Dunstan [EMAIL PROTECTED] wrote:
Magnus Hagander wrote:
Andrew Dunstan wrote:
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
OK. Where would be a good place to put the code? Maybe a
On Tue, Oct 21, 2008 at 9:34 AM, Magnus Hagander [EMAIL PROTECTED] wrote:
On 20 okt 2008, at 16.51, Andrew Dunstan [EMAIL PROTECTED] wrote:
No, it's not just a hack. It's very close to what we'd probably do if we
built the facility right into the language, although it does involve the
Magnus Hagander [EMAIL PROTECTED] writes:
In that case, why not put the trigger in core so people can use it
easily?
One advantage of making it a contrib module is that discussing how/when
to use it would fit more easily into the structure of the
documentation. There is no place in our docs
I share Tom's thoughts completely. My personal goal is definitely to make ecpg
parser generation a fully automated task. The only manual work I see in the
future is adding some special ecpg handling. I fully expect this script to
generate a working parser for every single change in gram.y.
On Tue, Oct 21, 2008 at 4:21 AM, Matthieu Imbert
[EMAIL PROTECTED] wrote:
Dear postgresql hackers,
I would like to be able to get results from SQL commands directly in a
binary format, instead of a textual one. Actually, I want to be able to
get timestamps with their full precision
Next stage is handling locks and proc interactions. While this has been
on Wiki for a while, I have made a few more improvements, so please read
again now.
Summary of Proposed Changes
---
* New RMgr using rmid==8 = RM_RELATION_ID (which fills last gap)
* Write new WAL
Hello
try to http://svana.org/kleptog/pgsql/pgfsck.html
regards
Pavel Stehule
2008/10/21 BRUSSER Michael [EMAIL PROTECTED]:
I need to repair the old version of Postgresql.
pg_dump does not work, I tried few other things but could not come up with
any workable scenario.
Any help will be
Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
In that case, why not put the trigger in core so people can use it
easily?
One advantage of making it a contrib module is that discussing how/when
to use it would fit more easily into the structure of the
documentation.
On Tue, 2008-10-21 at 09:44 +0200, Zeugswetter Andreas OSB sIT wrote:
* pg_last_recovered_xact_xid()
Will throw an ERROR if *not* executed in recovery mode.
returns bigint
* pg_last_completed_xact_xid()
Will throw an ERROR *if* executed in recovery mode.
returns bigint
Michael Meskes [EMAIL PROTECTED] writes:
... The only manual work I see in the
future is adding some special ecpg handling. I fully expect this script to
generate a working parser for every single change in gram.y. However, if some
new rule needs a different aka non-default handling in ecpg
On Tue, Oct 21, 2008 at 01:37:44PM +0200, Matthieu Imbert wrote:
Yes microseconds are available in textual mode but i do want to use binary
mode. Let me explain why:
...
if i'm correct, it seems obvious that the second scenario is more efficient
(and less ugly).
I wouldn't bet on scenario
On Fri, 2008-09-05 at 15:39 +0300, Marko Kreen wrote:
In the previous discussion there was mentioned that Postgres should
move to the SQL-MED direction in remote connection handling.
SQL-MED specifies that connections should have names and referenced
everywhere using names.
Where did you
Hi everybody,
me and Gabriele Bartolini have been working on Bitmap Indexes (BMI) in
the last weeks, with advice and guidance from Simon Riggs. We feel
that we are about to approach the point where it is appropriate to ask
for feedback from this list.
Thank you,
Dr. Gianni Ciolli - 2ndQuadrant
On Tue, Oct 21, 2008 at 02:41:11PM +0300, Peter Eisentraut wrote:
Preventing casual snooping without preventing MitM is a rational choice
for system administrators.
I am not an expert in these things, but it seems to me that someone who
can casually snoop can also casually insert DHCP or
On Tue, Oct 21, 2008 at 08:31:54AM -0400, Tom Lane wrote:
So it's all pretty messy and neither choice is exactly desirable. I
think maintaining parallel versions of an ecpg parser generator
would be no fun at all, though, so the perl choice seems more or
less forced. We could either
WHERE '12814474045' IN (people.home_phone, people.work_phone,
people.mobile_phone)
Yeah, not exactly a common case, but at least in 8.1 this was turned
into a set of ORs. Starting in 8.2 and in current HEAD, the planner
turns that into:
Filter: ('12814474045'::text = ANY
On Tuesday 21 October 2008 15:47:35 Tom Lane wrote:
Gregory Stark [EMAIL PROTECTED] writes:
Sort of. SSH requires you to install the certificate of the server
locally before connecting. If you don't it pops up a big warning and asks
if you want to install it. On subsequent connections it
Hi,
I'm trying to see if it makes sense to do the double-buffering of page
writes before going further ahead with CRC checking. I came up with the
attached patch; it does the double-buffering inconditionally, because as
it was said, it allows releasing the io_in_progress lock (and resetting
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2008-10-20 at 16:18 +0100, Simon Riggs wrote:
On Mon, 2008-10-20 at 14:26 +, Peter Eisentraut wrote:
SQL 200N - SQL:2003
Why not SQL:2008?
Peter?
If the comment was meant to refer to SQL:2003 originally, it should
probably be left that
I am going to do some hardware upgrading on buildfarm Cardinal. It will be
down for sometime.
Regards,
Gevik
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Tue, Oct 21, 2008 at 08:45:11AM -0700, David Fetter wrote:
As against that ... does a2p produce code that is
readable/maintainable?
Not that I've seen. There are modules on CPAN (I know, I know) for
dealing with lexx and yacc, and those are probably better for the
purpose.
Well I
Jim 'Decibel!' Nasby [EMAIL PROTECTED] writes:
WHERE '12814474045' IN (people.home_phone, people.work_phone,
people.mobile_phone)
Yeah, not exactly a common case, but at least in 8.1 this was turned
into a set of ORs. Starting in 8.2 and in current HEAD, the planner
turns that
Currently, the constructs
'{}'::arraytype
ARRAY[]::arraytype
return zero-dimensional arrays, as does the underlying function
construct_empty_array(). I can't immediately find any way at SQL
level to produce an empty array with one or more dimensions.
However, construct_array and
Hannu Krosing wrote:
In my brief reading of SQL-MED spec I could only find info on defining
FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one
define connection parameters like username and password.
It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take
2008/10/21 Tom Lane [EMAIL PROTECTED]:
Currently, the constructs
'{}'::arraytype
ARRAY[]::arraytype
return zero-dimensional arrays, as does the underlying function
construct_empty_array(). I can't immediately find any way at SQL
level to produce an empty array with one or more
Merlin Moncure [EMAIL PROTECTED] writes:
ISTM this is the way it should work from SQL level:
'{}'::int[] empty 1d
'{{},{}}'::int[] :: empty 2d
The first one looks okay, but ISTM the second one is not describing
an empty array: the upper dimension is of length 2. In particular
I think that
On Oct 21, 2008, at 12:06 PM, Tom Lane wrote:
Jim 'Decibel!' Nasby [EMAIL PROTECTED] writes:
WHERE 'xxx' IN (people.home_phone, people.work_phone,
people.mobile_phone)
Yeah, not exactly a common case, but at least in 8.1 this was turned
into a set of ORs. Starting in 8.2 and
On Tue, Oct 21, 2008 at 2:23 PM, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
ISTM this is the way it should work from SQL level:
'{}'::int[] empty 1d
'{{},{}}'::int[] :: empty 2d
The first one looks okay, but ISTM the second one is not describing
an empty
On Tue, 2008-10-21 at 13:50 -0400, Tom Lane wrote:
Currently, the constructs
'{}'::arraytype
ARRAY[]::arraytype
return zero-dimensional arrays, as does the underlying function
construct_empty_array(). I can't immediately find any way at SQL
level to produce an empty array with
On Tuesday 21 October 2008 19:59:02 Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2008-10-20 at 16:18 +0100, Simon Riggs wrote:
On Mon, 2008-10-20 at 14:26 +, Peter Eisentraut wrote:
SQL 200N - SQL:2003
Why not SQL:2008?
Peter?
If the comment was meant to refer
I have a client who mistakenly gave the postgres user on a windows
machine admin privileges.
This mistake results in the service being unable to start up due to
postgres refusing to start with admin privileges.
The error message from pg_ctl start -D bindir is PG_CTL..could not
locate
On Oct 21, 2008, at 12:08, Simon Riggs wrote:
Please remove zero-dimension arrays.
The number of dimensions of an empty array really ought to be NULL, or
if we fix it to be non-NULL then 1+. Zero just makes a weird case
for no
reason. An empty string only makes sense in the context of that
David E. Wheeler wrote:
On Oct 21, 2008, at 12:08, Simon Riggs wrote:
If we got rid of zero dimension arrays, how would I declare a new empty
array in a PL/pgSQL function?
Why would you want to do that? Is there a use case for that?
--
Andrew Chernow
eSilo, LLC
every bit counts
Decibel! [EMAIL PROTECTED] writes:
On Oct 21, 2008, at 12:06 PM, Tom Lane wrote:
Jim 'Decibel!' Nasby [EMAIL PROTECTED] writes:
Filter: ('xxx'::text = ANY ((ARRAY[home_phone, mobile_phone,
work_phone])::text[]))
Which means automatic seqscan.
It means no such thing.
It won't
Hi Jeffrey,
thank you for the suggestion. Yes, they potentially can, we'll consider
this.
Julo
Jeffrey Baker wrote:
I don't see why multiple CPUs can't work on the same node of a plan.
For instance, consider a node involving a scan with an expensive
condition, like UTF-8 string length.
On Oct 21, 2008, at 13:00, Andrew Chernow wrote:
On Oct 21, 2008, at 12:08, Simon Riggs wrote:
If we got rid of zero dimension arrays, how would I declare a new
empty array in a PL/pgSQL function?
Why would you want to do that? Is there a use case for that?
Perhaps not. In older versions
David E. Wheeler [EMAIL PROTECTED] writes:
If we got rid of zero dimension arrays, how would I declare a new
empty array in a PL/pgSQL function?
Same as before, I think: initialize it to '{}'. What's at stake here
is exactly what does that notation mean ...
regards,
On Oct 21, 2008, at 13:58, Tom Lane wrote:
If we got rid of zero dimension arrays, how would I declare a new
empty array in a PL/pgSQL function?
Same as before, I think: initialize it to '{}'. What's at stake here
is exactly what does that notation mean ...
An empty, single-dimension
An empty, single-dimension array. But I got the impression from Simon
that he thought it should be NULL.
I disagree with Simon *if* that's what he's saying. '{}' isn't equivalent
to NULL any more than 0 or '' is. NULL means I don't know / Doesn't
apply wheras '{}' means purposefully left
David E. Wheeler [EMAIL PROTECTED] writes:
On Oct 21, 2008, at 13:58, Tom Lane wrote:
Same as before, I think: initialize it to '{}'. What's at stake here
is exactly what does that notation mean ...
An empty, single-dimension array. But I got the impression from Simon
that he thought it
Gianni,
me and Gabriele Bartolini have been working on Bitmap Indexes (BMI) in
the last weeks, with advice and guidance from Simon Riggs. We feel
that we are about to approach the point where it is appropriate to ask
for feedback from this list.
The other major issue with the Bitmap index
On Oct 21, 2008, at 14:16, Tom Lane wrote:
Well, we can't do that because it would clearly break too much
existing
code. '{}' has got to result in something you can successfully
concatenate more elements to.
Right, that's what I was trying to day. Badly, I guess.
But either the current
Dave Cramer [EMAIL PROTECTED] writes:
I have a client who mistakenly gave the postgres user on a windows
machine admin privileges.
This mistake results in the service being unable to start up due to
postgres refusing to start with admin privileges.
The error message from pg_ctl start -D
On Tue, Oct 21, 2008 at 1:50 PM, Tom Lane [EMAIL PROTECTED] wrote:
Currently, the constructs
'{}'::arraytype
ARRAY[]::arraytype
return zero-dimensional arrays, as does the underlying function
construct_empty_array(). I can't immediately find any way at SQL
level to produce an
Seems like we ought to clean this up. I'm not sure which way to jump
though: should we decree that arrays of no elements must always have
zero dimensions, or should we get rid of that and standardize on, say,
1-D array with lower bound 1 and upper bound 0?
Isn't the zero-dimensional array
On 21-Oct-08, at 5:24 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
I have a client who mistakenly gave the postgres user on a windows
machine admin privileges.
This mistake results in the service being unable to start up due to
postgres refusing to start with admin privileges.
On Tue, 2008-10-21 at 21:05 +0300, Martin Pihlak wrote:
Hannu Krosing wrote:
In my brief reading of SQL-MED spec I could only find info on defining
FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one
define connection parameters like username and password.
It is
Tom Lane [EMAIL PROTECTED] writes:
Works fine for me, eg
...
- Bitmap Heap Scan on tenk1 b (cost=0.79..4.82 rows=3 width=244)
Recheck Cond: (b.unique2 = ANY (ARRAY[a.unique1, a.ten, a.hundred]))
- Bitmap Index Scan on tenk1_unique2 (cost=0.00..0.79 rows=3
width=0
)
Josh Berkus [EMAIL PROTECTED] writes:
Gianni,
me and Gabriele Bartolini have been working on Bitmap Indexes (BMI) in
the last weeks, with advice and guidance from Simon Riggs. We feel
that we are about to approach the point where it is appropriate to ask
for feedback from this list.
The
I can confirm that bringing Postgres code to multi-thread implementation
requires quite a bit of ground work. I have been working for a long
while
with a Postgres 7.* fork that uses pthreads rather than processes.
The effort
to make all the subsystems thread safe took some time and touched
Dave Cramer [EMAIL PROTECTED] writes:
On 21-Oct-08, at 5:24 PM, Tom Lane wrote:
It's fairly hard to see how that mistake leads to that symptom.
Can you poke a bit more into exactly what is happening?
when I executed postgres.exe directly it complained of the user having
admin privs
With
Gregory Stark [EMAIL PROTECTED] writes:
Josh Berkus [EMAIL PROTECTED] writes:
The other major issue with the Bitmap index patch as it stood in 2007 was
that performance just wasn't that much faster than a btree, except for
specific corner cases. Otherwise, someone else would have been
90 matches
Mail list logo