No it isn't a typo,
All the tables are empty and all the indexes are empty
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Tuesday, June 04, 2013 16:10
To: Ben Zeev, Lior
Cc: Atri Sharma; Stephen Frost; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Pr
Sharma [mailto:atri.j...@gmail.com]
Sent: Monday, May 27, 2013 17:24
To: Stephen Frost
Cc: Ben Zeev, Lior; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
>We may still be able to do better than what we're doing
> today, but I'm still suspicious that you
doesn't log the catcache statistcs
Lior
-Original Message-
From: Stephen Frost [mailto:sfr...@snowman.net]
Sent: Monday, May 27, 2013 16:44
To: Ben Zeev, Lior
Cc: Atri Sharma; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
* Ben Zeev, Lior (lior.ben-z...@h
Great, Thanks !!!
I will try and let you update
-Original Message-
From: Stephen Frost [mailto:sfr...@snowman.net]
Sent: Monday, May 27, 2013 16:29
To: Ben Zeev, Lior
Cc: Atri Sharma; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
Lior,
* Ben Zeev, Lior
Hi Stephen,
Each query is running in a separate transaction.
Why does portioning is done better rather than using partial index?
Thanks,
Lior
-Original Message-
From: Stephen Frost [mailto:sfr...@snowman.net]
Sent: Monday, May 27, 2013 16:15
To: Ben Zeev, Lior
Cc: Atri Sharma; Pg
ost [mailto:sfr...@snowman.net]
Sent: Monday, May 27, 2013 15:43
To: Ben Zeev, Lior
Cc: Atri Sharma; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
Lior,
* Ben Zeev, Lior (lior.ben-z...@hp.com) wrote:
> The case which I'm seeing is that I have an empty table with
Hi Atri,
But TOAST only occur if the tuple size exceed 2KB, doesn't it?
Lior
-Original Message-
From: Atri Sharma [mailto:atri.j...@gmail.com]
Sent: Monday, May 27, 2013 15:39
To: Ben Zeev, Lior
Cc: Stephen Frost; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process m
= 20GB of memory
What is the reason to consume so much memory for empty indexes?
Thanks,
Lior
-Original Message-
From: Stephen Frost [mailto:sfr...@snowman.net]
Sent: Monday, May 27, 2013 15:16
To: Atri Sharma
Cc: Ben Zeev, Lior; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Proc
...@gmail.com]
Sent: Monday, May 27, 2013 13:19
To: Ben Zeev, Lior; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture
On Mon, May 27, 2013 at 3:41 PM, Ben Zeev, Lior wrote:
> Hi Atri,
>
> Thanks for your answer!
> Do you have idea what may be the reason that Postgr
Hi,
I have a question regarding the memory consumption per process in PostgreSQL 9.2
Does each PostgreSQL process allocating in its own memory (Not shared memory) a
cache of all the database catalog which it access during the SQL execution?
I mean does each process holds all the catalog indexes
-zyp-json-schema-03#section-5.23
). XSD is fully compatible with ECMAScript 5 date time string format (http://es5.github.com/#x15.9.1.15
) so i'm going to sit on this again for a little while and think some
more. maybe try to convince json-schema to relax their definition of
date-time format.
i'll be back when i have a clear picture of what i think makes the
most sense.
thanks,
ben...
do you think
there would need to be an ECMA datestyle or would XSD be compatible with
this change?
i haven't touched any c code in quite a while but the changes look
simple enough that i could work towards an ECMA patch if that's the best
way to go about this.
thanks,
ben...
--
wed. i'll wait to see what happens.
thanks,
ben...
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
e format somewhere between the database and the browser.
i'm not familiar with the process of getting this feature added to
postgres - what needs to happen now?
ben...
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
g any more noise about this.
pavel, is there a way i can use this currently? if not, would it take
much effort to make this public?
thanks,
ben...
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
has there been other threads discussing this more recently?
thanks,
ben...
On Wed, May 19, 2010 at 6:21 AM, Pavel Stehule wrote:
>
>
> I am not a security expert - you can simply don't allow apostrophe,
> double quotes - but I am not sure, if this can be safe - simply - I am
>
thanks for the prompt reply.
On Oct 28, 2010, at 10:50 AM, Tom Lane wrote:
>> 1 - am i wrong in my assessment? is the constant contsel, areasel, etc
>> hurting us?
>
> The stub selectivity functions definitely suck.
i'm taking this as implying that my intuition here is basically right.
>> 2
4 rows=35769 loops=1)
Total runtime: 2596.653 ms
what i would really like to do is to inform the planner that the row counts and
selectivity of the gist index are such that it is better to use the index in
most every situation. i have run vacuum analyze but it does not seem to help.
alternativ
On May 19, 2010, at 4:31 AM, Mike Fowler wrote:
Pavel Stehule wrote:
2010/5/19 Peter Eisentraut :
On tis, 2010-05-18 at 18:26 -0400, Ben Hockey wrote:
ecmascript 5 is the most recent specification for JavaScript and i
would think that having a DATESTYLE format to simplify
interoperability
at is as follows: -MM-DDTHH:mm:ss.sssZ
ecmascript 5 is the most recent specification for JavaScript and i
would think that having a DATESTYLE format to simplify
interoperability with JavaScript applications would be highly desirable.
thanks,
ben...
On May 16, 2010, at 2:22 AM, Pavel St
>No, we don't have any concept of member functions. Just create the
>composite type (I'm assuming it needs to be composite) and then create
>functions that take it as parameter.
>
>Note that because PG allows function overloading, there's no conflict
>between, say, to_string(D_Temp_Element) a
Hello,
I've a Oracle type that I must translate to Postgres. This Oracle type is like
below :
CREATE OR REPLACE
type D_Temp_Element as object
(
MEMBER FUNCTION to_string return Varchar2,
MEMBER FUNCTION duration return D_Interval,
...
) ;
How can I do that in Postgres ? Is there somet
Thanks ! Now, it works fine.
Greg Stark wrote:
> Personally I'm of the opinion we should eliminate most of these
> duplicative mailing lists like -performance and -interfaces and just
> use -general. I don't see that having multiple lists for user
> questions helps either the users or th
Hello,
I posted my problem (on pgsql-interfaces list) about the INOUT parameters on
PostgreSQL 8.3.6 (Win32), but without success. I re-post my question here,
while hoping to have more success.
When I use a function with one INOUT (or OUT) parameter like below, everyting
is OK.
CREATE OR REP
s in their names.
(Beware, there was once a bug in Windows where renaming Foo to foo
accidentally deleted the file. It is therefore safer to rename Foo to
bar then bar to foo. However this is a moot point since I doubt that
anyone would actually run a brand new PostgreSQL datab
On 9/3/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ben Tilly" <[EMAIL PROTECTED]> writes:
> > That raises a very random thought. One of the nicer features of
> > Oracle is the ability to have function-based indexes. So you could
> > index, say, t
ve a column defined to hold the
result of the function, maintain that column with a trigger, then
index that column. Which works, but is inelegant. (It also requires
storing completely redundant data.)
Is there any prospect of postgres aquiring that functionality?
Ben
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
cussing well enough to know if this is
relevant, but what you just said is not always true. If there is any
way to pass arbitrary binary data into your function call, then
someone can pass in a string with nul in it. When that hits the OS
API, your appended .dict won'
diate solution (say a-z and 0-9), and plan to later allow
arbitrary data to be passed in, then be encoded in some way before
hitting disk. (And later need not be much later - such encodings are
not that hard to write.)
Cheers,
Ben
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 8/23/07, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
> Ben Tilly wrote:
> > On 8/22/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> >> On Aug 22, 2007, at 20:49 , Ben Tilly wrote:
> >>
> >>> If your implementation accepts:
> >>>
On 8/23/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> On Aug 23, 2007, at 10:47 , Ben Tilly wrote:
[...]
> > Why does it seem like a bug to you?
> >
> > Turn it around, and tell me in what way is its behaviour surprising to
> > someone who knows SQL. You as
rwards compatible with
any reasonable future standard.
As verification I asked a certified Oracle DBA. His understanding is
that Oracle may choose to rewrite the query for you or not. If it
does not rewrite the query, then it has an internal identifier but
there is no way you can get to it.
Cheers,
Be
On 8/22/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 22, 2007, at 20:36 , Ben Tilly wrote:
[...]
> > I can well believe that the standard says that you must accept
> > subqueries with aliases. But does it say you must reject subqueries
> > without a
On 8/23/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ben Tilly" <[EMAIL PROTECTED]> writes:
> > ... But then I need this (possibly
> > empty) list to have a valid group by statement at the end. In Oracle
> > I used to just write it like this:
>
&g
On 8/22/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 22, 2007, at 20:49 , Ben Tilly wrote:
>
> > If your implementation accepts:
> >
> > group by case when true then 'foo' end
>
> What would that mean? Regardless of whether or n
On 8/22/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
>
> "Ben Tilly" <[EMAIL PROTECTED]> writes:
>
> > Hopefully this is the right place for a few feature requests that
> > would address some of the things that I've noticed in postgres.
> >
>
On 8/22/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
>
> On Aug 22, 2007, at 18:45 , Ben Tilly wrote:
>
> > 1. Just a minor annoyance, but why must subqueries in FROM clauses
> > have an alias?
>
> It's required by the SQL standard, AIUI. I wonder what En
entirely redundant information. (But they're not EXACTLY the
same as the select clauses that they are redundant with...)
Cheers,
Ben
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
path?
Thanks!
Ben Clewett.
---(end of broadcast)---
TIP 6: explain analyze is your friend
not, if you can just send me the
prototype/macro expansion for 'elog' and the constant values that are
passed in the case where it exits, I'll add that config. Thanks!
-ben
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
constant, the above #ifdef should absolutely do the trick for us so we
know to stop analyzing on that path...Let me know if it doesn't actually
do that ;)
-ben
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
priate forum for this type of message.
Many thanks for reading this far...
-ben
Ben Chelf
Chief Technology Officer
Coverity, Inc.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
OK. It just doesn't seem obvious why.
Regards,
Ben
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Ben Trewern" <[EMAIL PROTECTED]> writes:
>> If I have one database say db1 and then do:
>> ALTER DATABASE db1 SET D
of them get carried accross.
Regards,
Ben
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
es a particular problem)
It is far more reliable if you output your data as an HTML table, in which
case it
practically always gets it right. Perhaps Postgres could support this as
an import/
export mechanism as I have found it to be far less error prone than CSV?
Cheers,
Ben Young
>
Postgres 7.0.2
Problem
---
I am having a rather
big problem with an installation of postgres 7.0.2 on cobalt, in that the db
server is unable to see any of the data stored in the (only) database which is
running (other than template1). I suspect that the fi
UNSUBSCRIBE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I sent this message to pgsql-performance yesterday, but as of now (about 30
hours later) I haven't yet received a response. So I figured I'd see what
you guys think. Please help if you can. Thanks!
==
I am having some problems with user-defined functions in version 7.3. The
planner se
in
case, I was wondering if there was a way to turn off the PLANNER.
Note, when I say an enormous amount of time, I mean at least double the
time the EXECUTOR takes to actually answer the query.
Thanks for your help,
Ben McMahan
ps. here is a small example of what my queries look like (so you can
in
case, I was wondering if there was a way to turn off the PLANNER.
Note, when I say an enormous amount of time, I mean at least double the
time the EXECUTOR takes to actually answer the query.
Thanks for your help,
Ben McMahan
ps. here is a small example of what my queries look like (so you can
now that's
worked around by my 'reset_logcnt' flag in the patch, but I know that it
may not be an ideal solution. But, since sequences are just tuples like
everything else I don't see an obvious way to prevent it.
-- Ben
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Fri, 15 Mar 2002, Tom Lane wrote:
> "'Ben Grimm'" <[EMAIL PROTECTED]> writes:
> > When these bugs are fixed there is still the issue of bug #3 that I
> > came across. The one that I work around by resetting log_cnt to 0 when a
> > backend in
esses a sequence for the first time.
That's probably overkill... But I still believe that the XLogFlush
after XLogInsert is necessary to ensure that the WAL value is written
to disk immediately. In my testing this patch works fine, YMMV.
-- Ben
*** src/backend/commands/sequence.c.orig
ence fall back
to its initial state. The XLogInserts that occur from the table
inserts must not happen in the same xact as the nextval's
XLogInserts. I can demonstrate the behavior quite easilly, and
Bruce posted results that confirmed it.
-- Ben
---(end of broad
Title: RE: [HACKERS] Postgre SQL for Windows
There is a link to sqlSQL for win32 here http://208.160.255.143/pgsql/pgsql.exe . Not tried it yet but it has been posted here before.
Regards
Ben
> -Original Message-
> From: Peter T Mount [mailto:[EMAIL PROTECTED]]
>
int out that to make Postgres easier for the simpletons on this planet i.e. myself, could you make it one of your priorities to work on some of these probs.
Hopefully for 7.2 - 7.3
Anyway
Thanks for all the work so far.
Ben
now is still in beta testing.
Not sure if this is such a good idea as it may give PostgreSQL a bad name.
Regards
Ben Trewern
57 matches
Mail list logo
