Dear sir:
Now ,I face a problem of expanding structure shmemvariableCache in the share memory.
When it comes togive value to this new field.I can;t initialize the system.
Thank you for your respond!
Do You Yahoo!?
60
On Monday 08 March 2004 23:28, Simon Riggs wrote:
PITR Functional Design v2 for 7.5
Blimey - that's a long post :-) Thanks for explaining things simply enough
that a non-hacker like me can understand. Well - almost understand ;-)
Review of current Crash Recovery
Is there any value in putting
Here is the patch I promised (against current). Regression tests all
passed. One thing I have not checked is the doc(lock.sgml). For some
reason I failed to install docbook V4.2 (I have working docbook V3.1
though), and I couldn't test the correctness of the file. Also, it
would be nice if some
I think the thread you're thinking of is on or about this post:
http://archives.postgresql.org/pgsql-patches/2003-12/msg00039.php
Manfred Koizar produced a patch that modified index correlation by
sorting equal key values based on item pointers. The patch went as far
as getting accepted into the
Bruce Momjian wrote:
Andrew Dunstan wrote:
After this is applied (fingers crossed) and everyone is happy, I will
submit a patch to remove log_timestamp, log_pid and (if we are agreed on
it) log_source_port.
I have applied this patch. It will be a great addition to PostgreSQL.
Is
Robert Treat [EMAIL PROTECTED] writes:
I think the thread you're thinking of is on or about this post:
http://archives.postgresql.org/pgsql-patches/2003-12/msg00039.php
Manfred Koizar produced a patch that modified index correlation by
sorting equal key values based on item pointers. The patch
Tatsuo Ishii [EMAIL PROTECTED] writes:
Here is the patch I promised (against current).
This is missing the necessary adjustments in backend/nodes/ (copy and
equal funcs). Also the NOWAIT keyword must be added to the list of
nonreserved keywords near the bottom of gram.y.
Andrew Dunstan [EMAIL PROTECTED] writes:
After this is applied (fingers crossed) and everyone is happy, I will
submit a patch to remove log_timestamp, log_pid and (if we are agreed on
it) log_source_port.
Is there agreement on removing these 3 config vars?
Now that I look at it,
After this is applied (fingers crossed) and everyone is happy, I will
submit a patch to remove log_timestamp, log_pid and (if we are agreed on
it) log_source_port.
Is there agreement on removing these 3 config vars?
There is from me.
---(end of
Guys,
Hm, that had nothing to do with multi-column correlation though.
I'm at a loss to think of any work that matches with Josh's
recollection.
H it's possible that early e-mails about Manfred's patch claimed to
improve performance for multi-column indexes.
But it's also
On Sun, 7 Mar 2004, Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
Tom Lane wrote:
This is something we need to consider, but we'll need more evidence
before making a choice. One thing that we have very little data about
is how much difference it makes in the quality of planner
Shridhar, Once the patches I've put forward are applied there's still
a further change I've got planned which will remove the mutex locking
in the common case - a NULL/DEFAULT connection parameter (I'll post a
patch soon). This leaves the threaded case with comparable performance
to the
Shridhar Daithankar wrote:
On Sunday 07 March 2004 09:16, Tom Lane wrote:
Personally I consider -c format the only one of the three that is
readable for reviewing purposes, so even if I weren't intending
immediate application, I'd ask for -c before looking at the patch.
There are some
Simon,
First off, let me compliment you on such a thourough proposal. I'm feeling
very enthusiastic about 7.5 PITR based on the amount of thought you've given
the project.
Based on throuroughness, I wanted to make a few comments and suggestions.
All of the below are in the category of
Hi!
Could we have the output from psqlscan.l (in src/bin/psql) added to the
nightly snapshots, the same way it's done with with the other flex
output files, please? It would do wonders for those of us too lazy to
fix their broken flex installations. And if the same script is used to
generate the
scott.marlowe [EMAIL PROTECTED] writes:
Hi Tom. I ran some very simple tests on analyze times and query plan
times on a very simple table, with data randomly distributed. The index
was on a date field, since that's what I was testing last.
Thanks.
I also ran some quick tests on smaller
Bruce Momjian wrote:
Shridhar Daithankar wrote:
I was wondering what people use to keep track of their personal development
especially when they do not have a cvs commit access.
See the developer's FAQ. They usually use cporig to make copies of
files they are going to modify, then difforig to
Lee Kindness wrote:
Shridhar, Once the patches I've put forward are applied there's still
a further change I've got planned which will remove the mutex locking
in the common case - a NULL/DEFAULT connection parameter (I'll post a
patch soon). This leaves the threaded case with comparable
Magnus Hagander wrote:
Could we have the output from psqlscan.l (in src/bin/psql) added to
the nightly snapshots, the same way it's done with with the other
flex output files, please?
Done.
---(end of broadcast)---
TIP 1: subscribe and
Peter Eisentraut [EMAIL PROTECTED] writes:
Magnus Hagander wrote:
Could we have the output from psqlscan.l (in src/bin/psql) added to
the nightly snapshots, the same way it's done with with the other
flex output files, please?
Done.
My apologies ... intended it to do that in the first
Fresh cvs tip checkout.
If I configure with --prefix then cvs tip seems to fail make check -
initdb fails with a complaint about a missing symbol for
canonicalise_path. If I don't set the prefix then it works fine. I don't
have any funny LD_LIBRARY_PATH stuff set.
cheers
andrew
Andrew Dunstan wrote:
Fresh cvs tip checkout.
If I configure with --prefix then cvs tip seems to fail make check -
initdb fails with a complaint about a missing symbol for
canonicalise_path. If I don't set the prefix then it works fine. I don't
have any funny LD_LIBRARY_PATH stuff set.
Andrew Dunstan wrote:
Fresh cvs tip checkout.
If I configure with --prefix then cvs tip seems to fail make check -
initdb fails with a complaint about a missing symbol for
canonicalise_path. If I don't set the prefix then it works fine. I
don't have any funny LD_LIBRARY_PATH stuff set.
Michael Chaney [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, Mar 01, 2004 at 09:42:48AM -0800, Steve Crawford wrote:
I missed the start of this thread but will chime in with a comment
anyway.
My rule is to select an appropriate numeric type of data if you will
be
Uytkownik Andrew Dunstan napisa:
(guess) try configuring without readline.
Or compile readline with your Mingw version, or just replace readline.a
with readline.dll in your lib directory.
All works with readline fine.
Best regards
Rony
---(end of
Lee Kindness wrote:
From: Bruce Momjian [EMAIL PROTECTED]
Lee Kindness wrote:
I still think it's worthwhile investigating the use of GCC's __thread
storage class specifier to remove the use of pthread_*specific in this
case. This would also be a help to the WIN32 port since this
IBM has rewritten their Domino database system to use the new
sys_epoll call available in the Linux 2.6 kernel.
Would Postgresql benefit from using this API? Is anyone looking at
this?
Anthony
http://xminc.com/mt/
---(end of broadcast)---
TIP 2:
Jonathan Gardner [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Friday 27 February 2004 12:01 pm, Halasipuram seshadri ramanujam wrote:
Hello ,
Can somebody please tell me how to get the name of the
relation (Attribute also) from the Oid and the
otherway back (Oid from
I recently had the 'joy' of needing to compile a copy of 7.1, to
support a fairly crusty application where we'd have to do more testing
than we can justify in order to upgrade to some (vastly) newer
generation.
Ran into a couple of things worth mentioning:
1. Had a whole lot of gory problems
Josh Berkus wrote:
5) Full back-up
Related to the above, what I don't see in your paper or the proposed API is a
way to coordinate full back-ups and WAL archiving. Obviously, the PITR
Archive is only useful in reference to an existing full backup, so it is
important to be able to associate
From: Bruce Momjian [EMAIL PROTECTED]
Lee Kindness wrote:
I still think it's worthwhile investigating the use of GCC's __thread
storage class specifier to remove the use of pthread_*specific in this
case. This would also be a help to the WIN32 port since this specifier
maps well to
In the last exciting episode, [EMAIL PROTECTED] (Jochem van Dieten) wrote:
Josh Berkus wrote:
I personally don't think that a GUI tool should be the province of
the Slony project. Seriously. I think that Slony should focus on
a command-line api and catalogs, and allow the existing GUI
Peter Eisentraut wrote:
Andrew Dunstan wrote:
If I configure with --prefix then cvs tip seems to fail make check -
initdb fails with a complaint about a missing symbol for
canonicalise_path. If I don't set the prefix then it works fine. I
don't have any funny LD_LIBRARY_PATH stuff set.
Tatsuo Ishii [EMAIL PROTECTED] writes:
Here is the patch I promised (against current).
This is missing the necessary adjustments in backend/nodes/ (copy and
equal funcs). Also the NOWAIT keyword must be added to the list of
nonreserved keywords near the bottom of gram.y.
Thanks for the
Hello,I made new system catalog.I think
it is successful.But i got an error whenI tried to select statement to get
content of this catalog.This error is"catalog is missing 2 attribute(s) for
relid 16652".So,I found the sourcecode that this error occurs.This file is
relcache.c.This
From: Bruce Momjian [EMAIL PROTECTED]
Lee Kindness wrote:
Perhaps a cleaner way is to use an existing thread package with
encompasses
the various platform APIs - i.e. APR or ACE, or... But that's a big
discussion, and not one I'm keen to get into at the moment. A more
appropriate time is
Andreas Pflug
Josh Berkus wrote:
Related to the above, what I don't see in your paper or the proposed
API
is a
way to coordinate full back-ups and WAL archiving. Obviously, the
PITR
Archive is only useful in reference to an existing full backup, so it
is
important to be able to associate a
Hello.
I have a table of 2'500'000 tuples and 100'000 pages, and an index
on non-unique field, to each key value corresponds approximately
50'000 tuples.
Due to the updating algorithm the physical order of tuples in the
table happens to be such that all equal keys are placed together,
but not
Greg Patnude [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Michael Chaney [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, Mar 01, 2004 at 09:42:48AM -0800, Steve Crawford wrote:
I missed the start of this thread but will chime in with a comment
anyway.
hi there i'm having troubles to find how to
GRANT SELECT ON all-tables-onmydb TO specificuser
this is just to give the access to specificuser to query the
database and find troubles on it
thnx for your time
---(end of
Tom Hebbron [EMAIL PROTECTED] writes:
If you need to use the path returned from the regclass cast as text, you
will need to create a cast from regclass to text - this can be achieved
using the following functions - making use of the cstring type that the
return/input functions for these types
Bruce Momjian [EMAIL PROTECTED] writes:
Tom, do you know how many of these issue are still open?
Uh, none of them, I would hope. That message was a long time ago.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't
Tom, do you know how many of these issue are still open?
---
Tom Lane wrote:
The IPv6 patch seems to still be a few bricks shy of a load. Grepping
for places that handle AF_INET but not AF_INET6 revealed these
A detailed proposal has now been published for PITR functionality.
I'd like to now request assistance from anybody and everybody that USEs
PostgreSQL, not just hackers, to work out a well-documented and
comprehensive test plan for PITR. (Some have offered, though volunteers
are required, so I
Bruce Momjian [EMAIL PROTECTED] writes:
This is for the 7.5/HEAD tree, so it is bumped. What we don't do is
bump during development.
No, we shouldn't do intermediate bumps during a devel cycle. Andrew,
did you have an earlier 7.5devel libpq.so installed someplace? If so
that's the gotcha you
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Turning off rpath in src/Makefile.global did the trick. I'm amazed this
hasn't caught me before - maybe libpq has just been so stable it hasn't
made a difference ... Should the version number be bumped? or is this
just a
Andrew Dunstan [EMAIL PROTECTED] writes:
Turning off rpath in src/Makefile.global did the trick. I'm amazed this
hasn't caught me before - maybe libpq has just been so stable it hasn't
made a difference ... Should the version number be bumped? or is this
just a developer gotcha?
If it
Simon,
SIGHUP - seems to allow different parameter settings in each backend
Nope. SIGHUP means that you need to send a HUP to the postmaster, such as
you would with changes to pg_hba.conf.
SUSET - maybe what you're looking for???
Yes. This means that it can be changed, at runtime,
Richard Huxton
On Monday 08 March 2004 23:28, Simon Riggs wrote:
PITR Functional Design v2 for 7.5
Review of current Crash Recovery
Is there any value in putting this section on techdocs or similar? We
do
get a
small but steady trickle of people asking for details on internals,
and I
Josh Berkus [mailto:[EMAIL PROTECTED]
First off, let me compliment you on such a thorough proposal. I'm
feeling very enthusiastic about 7.5 PITR
Thank you, though please realise that I am in many ways summarising a
wide range of suggestions and earlier work into a coherent whole.
Me too! I'm
hi there i'm having troubles to find how to
GRANT SELECT ON all-tables-onmydb TO specificuser
There isn't any such command. You need to write a stored procedure to
do it for you in a loop.
Chris
---(end of broadcast)---
TIP 1: subscribe and
Who can tell me how to
completeoracle's
hierarchical_query through
postgresql
This is missing the necessary adjustments in backend/nodes/ (copy and
equal funcs). Also the NOWAIT keyword must be added to the list of
nonreserved keywords near the bottom of gram.y.
Thanks for the review. I'll work on this.
Here is the revised patch.
--
Tatsuo Ishii
Try contrib/tablefunc
Chris
Li Yuexin wrote:
Who can tell me how to complete /oracle's / /hierarchical_query
/through postgresql/ /
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Simon Riggs [EMAIL PROTECTED] writes:
Strict behaviour is fairly straightforward, you just PANIC!
There is another mode possible as well. Oracle for example neither panics nor
continues, it just freezes. It keeps retrying the transaction until it finds
it has space.
The sysadmin or dba just
I am timing small queries, and found that a PREPARE/EXECUTE of SELECT
1 takes about 1.2ms on my machine. A normal SELECT doesn't take much
longer, so I am wondering why a simpler query isn't faster.
Looking at log_executor_stats, I see the following. Execute shows
nothing taking much time,
Alexey Nalbat [EMAIL PROTECTED] writes:
Due to the updating algorithm the physical order of tuples in the
table happens to be such that all equal keys are placed together,
but not ordered globally.
Hmm... this is of course a weak spot of the correlation-based estimation
method. If you were
At 04:08 PM 10/03/2004, Tom Lane wrote:
None at the moment, but I'm open to suggestions. It seems like we might
need different stats for equality probes than range probes.
What about my suggestion from August 2000:
There might be a way to side-step the issue here. I assume that
the index
Bruce Momjian [EMAIL PROTECTED] writes:
I am timing small queries, and found that a PREPARE/EXECUTE of SELECT
1 takes about 1.2ms on my machine. A normal SELECT doesn't take much
longer, so I am wondering why a simpler query isn't faster.
Define normal SELECT. I can think of plenty of people
Bill Moran [EMAIL PROTECTED] writes:
Am I missing something here?
Hmm. It seems like int-to-bit casting ought to be aware of the
bit-width one is casting to, and take that number of bits from
the right end of the integer. This would make it be the inverse
of the other direction. Right now
60 matches
Mail list logo