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 o
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
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 wer
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, mos
"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
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
> > 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
==
Who can tell me how to
complete oracle's
hierarchical_query through
postgresql。
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 u
>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
>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,
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,
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
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
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
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 wou
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
> unimple
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 i
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 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
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 broadcast)
"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
>
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 ord
>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
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
> > appropri
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 fil
> 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 f
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.
You
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
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 we
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 a
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 due
"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
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: yo
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 si
Użytkownik 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 broadcast)
"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 w
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.
Furthe
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 stuf
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
-
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 fi
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 unsubs
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 pe
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 sen
"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 sm
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 r
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 "extr
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
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 non-threade
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
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 pos
> >>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 broadcast
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,
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.
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
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 the
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 p
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 one
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 puttin
Dear sir:
Now ,I face a problem of expanding structure shmemvariableCache in the share memory.
When it comes to give value to this new field.I can;t initialize the system.
Thank you for your respond!
Do You Yahoo!?
完全免费的雅虎电邮，马上注册获赠额外6
60 matches
Mail list logo
