I wonder if I should use PlPython in my projects or not.
Browsing on the Python list it seems that nobody is using
it. Browsing on Google Groups I find worrysome threads talking
about removing support from it in future versions of PostgreSQL.
So, I would like to know what's the current status of
On May 27, 2007, at 1:19 PM, Robert Treat wrote:
On Friday 25 May 2007 12:39, Jaime Casanova wrote:
On 5/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Bernd Helmle [EMAIL PROTECTED] writes:
No, because the RemovePgTempFiles() call in PostmasterMain() will
remove all tmp files at startup.
I
I am doing a DLL project, it is in the backend/utils/mb. But it can not be
maked under windows mingw.
I require everyone to help me. Thank your very much.
The error infomations are as follows.
Info: resolving _CurrentMemoryContext by linking to __imp__CurrentMemoryContext
(auto-import)
Info:
Ühel kenal päeval, E, 2007-05-28 kell 20:57, kirjutas
[EMAIL PROTECTED]:
I wonder if I should use PlPython in my projects or not.
Browsing on the Python list it seems that nobody is using
it.
At least we are usingi it at Skype.
Browsing on Google Groups I find worrysome threads talking
Bruce Momjian [EMAIL PROTECTED] writes:
I tested TOAST using a method similar to the above method against CVS
HEAD, with default shared_buffers = 32MB and no assert()s. I created
backends with power-of-2 seetings for TOAST_TUPLES_PER_PAGE (4(default),
8, 16, 32, 64) which gives
I
would
like
to
leave
the
list
...
--
Acelerador POP
Acelere a sua conexo discada em at 19 x. Use o Acelerador POP. grtis, pegue j o seu.
http://www.pop.com.br/acelerador
Marcos Fabrício Corso wrote:
I would like to leave the list ...
Not really a question worth posting several lists. If you don't know how
to unsubscribe, try starting with the form linked from here.
http://www.postgresql.org/community/lists/
--
Richard Huxton
Archonet Ltd
Hi All,
I am new to this postgres and now struggling with creation of a user
specific to a database, so the user can login to that specific database
and can do the activities as per the given credentials and can not touch
or see any information from other databases. Can any one please help
On Mon, May 28, 2007 at 10:23:42PM -0400, Tom Lane wrote:
Tatsuo Ishii [EMAIL PROTECTED] writes:
I'm afraid we have to mke it larger, rather than smaller for 8.3. For
example 0x82f5 in SHIFT_JIS_2004 (new in 8.3) becomes *pair* of 3
bytes UTF_8 (0x00e3818b and 0x00e3829a). See
Tatsuo Ishii [EMAIL PROTECTED] writes:
Thinking more, it striked me that users can define arbitarily growing
rate by using CFREATE CONVERSION. So it seems we need functionality to
define the growing rate anyway.
Seems to me that would be an argument for moving the palloc inside the
conversion
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I tested TOAST using a method similar to the above method against CVS
HEAD, with default shared_buffers = 32MB and no assert()s. I created
backends with power-of-2 seetings for TOAST_TUPLES_PER_PAGE (4(default),
8, 16, 32,
Sahoo, Ranjan Rashmi wrote:
Hi All,
I am new to this postgres and now struggling with creation of a user
specific to a database, so the user can login to that specific database
and can do the activities as per the given credentials and can not touch
or see any information from other
On Tue, May 29, 2007 at 10:00:06AM -0400, Tom Lane wrote:
In practice though, I find it hard to imagine a pair of encodings for
which the growth rate is more than 3x. You'd need something that
translates a single-byte character into 4 or more bytes (pretty
unlikely, especially considering we
On Tue, May 29, 2007 20:51, Tatsuo Ishii wrote:
Thinking more, it striked me that users can define arbitarily growing
rate by using CFREATE CONVERSION. So it seems we need functionality to
define the growing rate anyway.
Would it make sense to define just the longest and shortest character
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I tested TOAST using a method similar to the above method against CVS
HEAD, with default shared_buffers = 32MB and no assert()s. I created
backends with power-of-2 seetings for
Gregory Stark [EMAIL PROTECTED] writes:
Is your database initialized with C locale? If so then length(text) is
optimized to not have to detoast:
if (pg_database_encoding_max_length() == 1)
PG_RETURN_INT32(toast_raw_datum_size(str) - VARHDRSZ);
Of course I got that wrong.
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I tested TOAST using a method similar to the above method against CVS
HEAD, with default shared_buffers = 32MB and no assert()s. I created
backends with
Bruce Momjian wrote:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I tested TOAST using a method similar to the above method against CVS
HEAD, with default shared_buffers = 32MB and no assert()s. I
Alvaro Herrera wrote:
Strangely, 128 bytes seems to be the break-even point for TOAST and
non-TOAST, even for sequential scans of the entire heap touching all
long row values. I am somewhat confused why TOAST has faster access
than inline heap data.
Is your database
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Is your database initialized with C locale? If so then length(text) is
optimized to not have to detoast:
if (pg_database_encoding_max_length() == 1)
PG_RETURN_INT32(toast_raw_datum_size(str) - VARHDRSZ);
Wow,
Bruce Momjian wrote:
My test uses random data, which I figured was a close to real-world as I
could get, and I have a test that makes sure the data was pushed to the
TOAST table. Should I still try EXTERNAL?
My point is that you probably want to measure separately the effect of
compression
Alvaro Herrera wrote:
Bruce Momjian wrote:
My test uses random data, which I figured was a close to real-world as I
could get, and I have a test that makes sure the data was pushed to the
TOAST table. Should I still try EXTERNAL?
My point is that you probably want to measure
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Is your database initialized with C locale? If so then length(text) is
optimized to not have to detoast:
if (pg_database_encoding_max_length() == 1)
Bruce Momjian [EMAIL PROTECTED] writes:
No, we did substring() too :)
Uh, I looked at text_substring(), and while there is an optimization to
do character counting for encoding length == 1, it is still accessing
the data.
Sure but it'll only access the first chunk. There are two chunks in
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
No, we did substring() too :)
Uh, I looked at text_substring(), and while there is an optimization to
do character counting for encoding length == 1, it is still accessing
the data.
Sure but it'll only access the first
On Wednesday 23 May 2007 1:04 pm, George Pavlov wrote:
Hoping to resurrect this thread. I am seeing more and more of
this as the database gets more usage and it really messes up
query log analysis.
A quick summary: When I posted this was getting corrupted
query log entries. I still am. They
Hi!
What exactly are you trying to build? If you have own-written Makefile
for this - post it here. Does your code contain #define BUILDING_DLL
before inclusion of PostgreSQL headers?
Wang Haiyong wrote:
I am doing a DLL project, it is in the backend/utils/mb. But it can
not be maked under
I would like to invite all the PostgreSQL developers/users and their
families who live near Philadelphia to a barbeque/pool party at my house
on Saturday, July 14, 3-7pm. Directions to my house are at:
http://momjian.us/main/directions.html
Please RSVP by Monday, July 9 with a count so
Hi!
When running on a 64-bit server, are 32-bit ints padded to 64-bit?
Specifically, I'm interested if I actually end up making my table any
smaller if I move from 64-bit integer primary key to 32-bit. (Need to
keep the index as small as possible to fit in cache)
64-bit on Debian linux running
We currently have processed 15 of the 40 patches in the patch queue
during our two months in feature freeze. Based on that progress, I
estimate we will enter beta in September.
While we have made progress on more than 15 patches, we also have left
many of the more complex patches to the end, so
Stephen, Tom,
Eeek. *Which* caller's search_path? The string you're handed
might've come from multiple levels up.
I would say the outer-most. If people inbetween want to mess with
things, let them qualify it before handing it down. Clearly, an
already-qualified object would be left
Bruce Momjian [EMAIL PROTECTED] writes:
Gurjeet Singh wrote:
But I did not understand the haste to commit the patch within almost half an
hour of proposing the second version of the patch!!!
It happens some times when a patch applier has gotten as far as they can
go with a patch and wants to
Magnus Hagander [EMAIL PROTECTED] writes:
Specifically, I'm interested if I actually end up making my table any
smaller if I move from 64-bit integer primary key to 32-bit.
Depends what else is in the row ... the overall row will get padded to
MAXALIGN, but if you were wasting 4 bytes on
Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Specifically, I'm interested if I actually end up making my table any
smaller if I move from 64-bit integer primary key to 32-bit.
Depends what else is in the row ... the overall row will get padded to
MAXALIGN, but if you were
Tom, Josh,
* Josh Berkus ([EMAIL PROTECTED]) wrote:
Based on further IRC, I can personally see a solution which would be
generally useful. Further, this solution doesn't require (or shouldn't)
any modification of the existing function_path solution. It just requires
two functions, which
Magnus Hagander [EMAIL PROTECTED] writes:
Specifically, I'm interested if I actually end up making my table any
smaller if I move from 64-bit integer primary key to 32-bit.
Depends what else is in the row ... the overall row will get padded to
MAXALIGN, but if you were wasting 4 bytes on
On Tue, 2007-29-05 at 16:01 -0400, Tom Lane wrote:
(I imagine someday we'll get around to allowing int8 to be pass-by-value
on 64-bit platforms.)
This could really be a significant performance win: I'm planning to take
a look at doing it for 8.4.
-Neil
---(end of
On 5/30/07, Tom Lane [EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Gurjeet Singh wrote:
But I did not understand the haste to commit the patch within almost
half an
hour of proposing the second version of the patch!!!
It happens some times when a patch applier has gotten
Gurjeet Singh [EMAIL PROTECTED] writes:
As for the current patch,I had only a few cosmetic changes in mind:
I don't actually find those suggestions to make it more readable,
rather the reverse ...
regards, tom lane
---(end of
On 5/18/07, Andrew Hammond [EMAIL PROTECTED] wrote:
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
What are the grounds for defining it that way rather than some other
way?
The only alternative
On 5/27/07, Robert Treat [EMAIL PROTECTED] wrote:
On Friday 25 May 2007 12:39, Jaime Casanova wrote:
On 5/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Bernd Helmle [EMAIL PROTECTED] writes:
--On Freitag, Mai 25, 2007 10:49:29 + Jaime Casanova
[EMAIL PROTECTED] wrote:
No, because
Andrew Hammond escribió:
Ok, I've been hunting through src/backend to try and find the code for
EXTRACT(epoch ...). I found EXTRACT in src/backend/parser/gram.y, which
seems like a reasonable place to start.
| EXTRACT '(' extract_list ')'
{
FuncCall *n = makeNode(FuncCall);
You are right. Thanks.
I found macro BUILDING_DLL in the file src/Makefile.port.
I move the DLL source code from the backend path. It can be successfully built.
The file Makefile.port contains
ifneq (,$(findstring backend,$(subdir)))
ifeq (,$(findstring
On Tuesday 29 May 2007 20:06, Jaime Casanova wrote:
On 5/27/07, Robert Treat [EMAIL PROTECTED] wrote:
On Friday 25 May 2007 12:39, Jaime Casanova wrote:
On 5/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Bernd Helmle [EMAIL PROTECTED] writes:
--On Freitag, Mai 25, 2007 10:49:29 +
Bruce Momjian wrote:
Gregory Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
No, we did substring() too :)
Uh, I looked at text_substring(), and while there is an optimization to
do character counting for encoding length == 1, it is still accessing
the data.
Sure but
Alvaro Herrera [EMAIL PROTECTED] writes:
Andrew Hammond escribió:
Which got me looking for date_part. But that only seems to be in the
gram.y file, include/catalog/pg_proc.h and the test suite. The pg_proc.h
stuff looks pretty interesting, but to decipher it, I figured I need to read
up on
Bruce Momjian [EMAIL PROTECTED] writes:
I reran the tests with hashtext(), and created a SUMMARY.HTML chart:
http://momjian.us/expire/TOAST/
I don't understand what the numbers in this chart are?
regards, tom lane
---(end of
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I reran the tests with hashtext(), and created a SUMMARY.HTML chart:
http://momjian.us/expire/TOAST/
I don't understand what the numbers in this chart are?
They are taken from the test script and output files that are also in
48 matches
Mail list logo