2012/9/14 John R Pierce :
> On 09/13/12 10:17 PM, Wells Oliver wrote:
>>
>> Do these tend to perform well? I have some simple formulas in functions
>> like so:
>
>
> if you code your function in SQL instead of plpgsql, and mark it immutable,
> it can be inlined by the planner.
you don't need to ma
On 09/13/12 10:17 PM, Wells Oliver wrote:
Do these tend to perform well? I have some simple formulas in
functions like so:
if you code your function in SQL instead of plpgsql, and mark it
immutable, it can be inlined by the planner.
--
john r pierceN 37, W 122
s
On Thursday, 13 September 2012 18:51:48 UTC+2, "Alexander Gataric" wrote:
> I need to determine relationships between several tables. Is there a free
> tool to extract these from catalog tables? Is there an SQL that also does
> this?
>
> Thanks
> Alex
>
> Sent from my smartphone
You can try D
2012/9/14 Wells Oliver :
> Do these tend to perform well? I have some simple formulas in functions like
> so:
>
> CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
> RETURNS numeric AS
> $BODY$
>
> declare ret numeric;
>
> begin
> select (a+b) / c::numeric into ret;
> re
Do these tend to perform well? I have some simple formulas in functions
like so:
CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
RETURNS numeric AS
$BODY$
declare ret numeric;
begin
select (a+b) / c::numeric into ret;
return round(ret, 3);
end
$BODY$
LANGUAGE plpgs
Le 2012-09-13 à 16:51, David Salisbury a écrit :
>
> It looks to me like you're misusing git..
>
> You should only git init once, and always use that directory.
> Then pg_dump, which should create one file per database
> with the file name you've specified.
> Not sure of the flags but I'd recom
I usually just forget her birthday, eye color, or name. Then she extracts
herself from the relationship.
QED.
On 09/13/2012 06:33 AM, Yelai, Ramkumar IN BLR STS wrote:
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I
went through the documents and articles to know how to get the table
size (_http://wiki
Em 13/09/2012 16:12, Kevin Grittner escreveu:
Edson Richter wrote:
Anything else I can do from here?
Did that result in more accurate numbers for pg_class.reltuples?
-Kevin
I don't how number were not accurate - for me they always seemed
consistent with what I knew about it...
Let's
"Andrus" wrote:
> After switching to PostgreSql 9.1 serializable transaction level
> for all transactions during posting single document errors
>
> 40001:ERROR: could not serialize access due to read/write
> dependencies among transactions
> Reason code: Canceled on identification as a pivot, dur
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I went
through the documents and articles to know how to get the table size
(http://wiki.postgresql.org/wiki/Disk_Usage)
But before let the user d
Peter Eisentraut writes:
> On 9/12/12 2:31 PM, Tom Lane wrote:
>> "C" is the official name of that locale. Not sure how you got it to say
>> "POSIX" ... maybe we didn't have normalization of the locale name back
>> then?
> Says who?
Says setlocale(), at least on the Fedora machine I just checke
On 09/13/2012 09:59 AM, Tom Lane wrote:
Alex Lai writes:
"EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
[vs]
"EXPLAIN insert into alex1 (fileid, archiveset) select '35352974', '10003';"
You might be happier using INSERT ... VALUES instead of INSERT
... SELECT
On 09/13/12 2:08 PM, Sébastien Lorion wrote:
I started db creation over, this time with 16GB maintenance_work_mem
and fsync=off and it does not seem to have a great effect. After again
5 hours, during index creation, disk and cpu are barely used: 95% idle
and 2-3 MB/s writes (150 reads/s, 90 wr
On Thu, 13 Sep 2012 11:51:42 -0500 "Alexander Gataric" wrote:
> I need to determine relationships between several tables. Is there a free
> tool to extract these from catalog tables? Is there an SQL that also does
> this?
I've gotten good results with schemaspy.
--
Bill Moran
--
Sent via
I started db creation over, this time with 16GB maintenance_work_mem and
fsync=off and it does not seem to have a great effect. After again 5 hours,
during index creation, disk and cpu are barely used: 95% idle and 2-3 MB/s
writes (150 reads/s, 90 writes/s).
Sébastien
On Thu, Sep 13, 2012 at 1:29
It looks to me like you're misusing git..
You should only git init once, and always use that directory.
Then pg_dump, which should create one file per database
with the file name you've specified.
Not sure of the flags but I'd recommend plain text format.
I'm also unsure what you mean by networ
From: Alexander Gataric [mailto:gata...@usa.net]
Sent: Thursday, September 13, 2012 12:52 PM
To: pgsql-general@postgresql.org
Subject: Best free tool for relationship extraction
I need to determine relationships between several tables. Is there a free tool
to extract these from catalog tables? I
AG> I need to determine relationships between several tables. Is there a
AG> free tool to extract these from catalog tables? Is there an SQL that
AG> also does this?
https://metacpan.org/module/DBIx::Class
It can't figure out m2m's though, for obvious reasons.
--
tetris is so unre
On 9/12/12 2:31 PM, Tom Lane wrote:
> "C" is the official name of that locale. Not sure how you got it to say
> "POSIX" ... maybe we didn't have normalization of the locale name back
> then?
Says who? I think C and POSIX are distinct locales that just happen to
behave the same way.
--
Sent v
I use Devart dotconnect for Postgresql at work and love it. I use it for
inserting into and querying a database of regression test results. I also use
it for managing a database of crash reports. I can't say anything bad about it.
One of the cool features
I like a lot is the amount of Get functi
I downloaded the LinqConnect demo, which is what I really need, and which seems
to work well. I'm unsure whether their Entity Developer tool is required with
it, or if I can get the context class I need for inclusion in a C# project some
other way, such as with something provided inside Visual
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Wednesday, September 12, 2012 11:00 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how long to wait on 9.2 bitrock installer?
On 09/12/12 10
Edson Richter wrote:
> Anything else I can do from here?
Did that result in more accurate numbers for pg_class.reltuples?
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Em 12/09/2012 21:50, Edson Richter escreveu:
Em 12/09/2012 15:09, Kevin Grittner escreveu:
VACUUM FREEZE VERBOSE ANALYZE
Sorry, most of the messages are in portuguese, but I guess numbers are
more important, right?
INFO: índice "pk_notafiscalarq" agora contém 715084 versões de
registros em
After switching to PostgreSql 9.1 serializable transaction level for all
transactions during posting single document errors
40001:ERROR: could not serialize access due to read/write dependencies among
transactions
Reason code: Canceled on identification as a pivot, during write.;
started to app
Hi Tom,
On the test box this seems to have completely resolved our problem.
I'll be scheduling an upgrade on the production cluster to verify it.
Thanks
On Thu, Sep 13, 2012 at 11:08 AM, Tom Lane wrote:
> Mike Roest writes:
> >We have a interesting thing happening on one of our DB's t
BTW, they'll probably take a day to respond since they're all in the Ukraine :)
They also seem to respond to questions fairly quickly on
StackOverflow, if you use the DevArt tag.
On Thu, Sep 13, 2012 at 10:26 AM, Rob Richardson
wrote:
> Replying partially to my own question:
>
>
>
> I downloaded
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Tom Lane replied:
> My recollection is that they're intentionally excluded because they
> would otherwise be security holes --- there are some format codes that
> allow direct access to memory, or something like that.
They are not part of th
Replying partially to my own question:
I downloaded the Express provider from DevArt. I then set them an E-mail as
scornfully as I possibly could write suggesting that if they are going to
provide samples with their code, the samples should probably be tested at least
once.
We'll see if their
> I would like to begin learning to use LINQ with PostgreSQL. Ideally, it
> would be good to have free tools to do it, since I probably won’t be
> finished playing with it before 30 days are up and I’d have to pay for
> something. It would also be good if whatever I use has a good set of
> tutori
Mike Roest writes:
>We have a interesting thing happening on one of our DB's that when
> autovacuum runs against the pg_catalog tables (or we run a manual vacuum)
> we get a large delay in opening new connections.
I think you're hitting the problem that was fixed here:
Author: Tom Lane
Bran
I need to determine relationships between several tables. Is there a free tool
to extract these from catalog tables? Is there an SQL that also does this?
Thanks
Alex
Sent from my smartphone
Greetings!
I would like to begin learning to use LINQ with PostgreSQL. Ideally, it would
be good to have free tools to do it, since I probably won't be finished playing
with it before 30 days are up and I'd have to pay for something. It would also
be good if whatever I use has a good set of t
Good Morning everyone,
We have a interesting thing happening on one of our DB's that when
autovacuum runs against the pg_catalog tables (or we run a manual vacuum)
we get a large delay in opening new connections. If this happens during a
busy period on our system we end up getting 200-300 con
On Thu, Sep 13, 2012 at 12:15 AM, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
>> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
>> from ./pgAdmin3.cpp:13:
>> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/st
Alex Lai writes:
>"EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
> [vs]
>"EXPLAIN insert into alex1 (fileid, archiveset) select '35352974',
> '10003';"
You might be happier using INSERT ... VALUES instead of INSERT
... SELECT for this. In the former, the parser
maintenance_work_mem is already 4GB. How large should it be during load
then ?
Sébastien
On Thu, Sep 13, 2012 at 1:29 AM, John R Pierce wrote:
> On 09/12/12 10:01 PM, Sébastien Lorion wrote:
>
>> pgbench initialization has been going on for almost 5 hours now and still
>> stuck before vacuum st
Hi Devrim,
Thank you for pointing these facts out. Very helpful and I now have my
installations working without issue.
Changing the scripts as you have done is very useful for parallel
installations. It will make my work easier.
Regards,
Jeremy
On 12/09/12 16:57, Devrim GUNDUZ wrote:
> Hi Jerem
I had same problem too.
My laptop : Windows 7 Pro 64bit and postgresql-9.2.0-1-windows-x64.exe.
But it ok when I install postgresql-9.2.0-1-windows.exe on my server
windows 2003 Ent 32 bit.
On Thu, Sep 13, 2012 at 12:59 PM, John R Pierce wrote:
> On 09/12/12 10:42 PM, Dann Corbit wrote:
>
>>
>
Hello.
I'm pleased to annouce that multicorn 0.9.2 has been released, which is
compatible with PostgreSQL 9.2 (but not 9.1 anymore).
The last release compatible with PG 9.1 is 0.9.1.
Version 0.9.2 major feature is the ability to declare columns which can be
used as parameterized paths.
This m
Hi,
On Wed, 2012-09-12 at 20:51 -0700, Mike Christensen wrote:
> In file included from ../pgadmin/include/pgAdmin3.h:24:0,
> from ./pgAdmin3.cpp:13:
> ../pgadmin/include/ctl/ctlSQLBox.h:17:24: fatal error: wx/stc/stc.h:
> No such file or directory
> compilation terminated.
Here
42 matches
Mail list logo
