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 als
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 broadcast)-
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
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
> > >
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, 200
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 conversion_procs,$(subdir
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(Func
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]> wrot
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?
>
> > Th
"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 broadcast)--
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 h
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 br
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
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, whi
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 w
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 ali
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
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
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 I
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
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!
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 wi
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
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 a
"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 ch
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)
> >>PG_RETURN_I
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
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
"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) - VA
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.
> >
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_bu
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 cre
"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 tha
"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
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
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
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 da
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),
> >
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
convers
> > 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 0x
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
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
--
I
would
like
to
leave
the
list
...
--
Acelerador POP
Acelere a sua conexão discada em até 19 x. Use o Acelerador POP. É grátis, pegue já o seu.
http://www.pop.com.br/acelerador
"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 TOAST/
Ü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
>
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: re
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 bel
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 Pl
48 matches
Mail list logo
