I also like the looks of Mogwai. I am using Dezign, and it's OK. It used
to be better in the last version. NOW, it can't print anything more than
10 entities on my machine, and it's 1gig of ram/1.8ghz. It does a jpeg
in 0.1 second, so what it's printing problem I don't know.
Anyway, I am mostly
A Palmblad wrote:
I'm writing a function in C, and am trying to return a row,
containing Numeric and array types. I'm building the row with
heap_formtuple. I'm having trouble creating the numeric and array
Datums. If anyone has some example code illustrating this, that'd be
great.
See PL/R for e
OK,
I've given up on the tool I'm using. Anyone recommend a good,
graphical ERD CASE tool for postgres? I'm on windblowsXP.
---(end of broadcast)---
TIP 8: explain analyze is your friend
Greg Stark wrote:
Personally I would have preferred bytea(16) but for some reason the php
drivers seem to jut drop NULL there when I try to store raw binary md5 hashes.
So for now I just declared it bytea with no length specification and store the
hex encoded hash.
If anyone knows how to get Pear::
Just added a rule to postfix's config file to try and clean up some of the
trash going through the server, namely:
smtpd_helo_restrictions =
permit_mynetworks,
reject_unknown_hostname,
reject_invalid_hostname,
reject_non_fqdn_hostname,
permit
smtpd_sender_
Eduardo Pérez Ureta <[EMAIL PROTECTED]> writes:
> I was wondering what the best way is to store a file hash (MD5 or SHA1)
> and make it primary key indexed.
> I have seen some people storing the hexadecimal encoded MD5 in a
> CHAR(32) but it may be a better idea to use a CHAR(16) without encoding
Could someone clarify the use of the –L option in
pg_restore? I have a pg_dump of a database (options –Ft –b) and I
want to restore most of the dump with the exception of one table into another
database. Can I do the following?:
1) restore the
tar file of the dump into a “list” fil
Jeff Boes <[EMAIL PROTECTED]> writes:
> At some point, someone was going to write a "white paper" detailing how one
> might go about setting these parameters.
In 7.4, it's relatively easy to check on whether your settings are
reasonable: just do a VACUUM VERBOSE (database-wide) and check the
FSM r
On Friday May 7 2004 12:20, Ed L. wrote:
>
> 1) I'm inclined to set this to handle as large a DB footprint as will be
> in the coming year or two, so maybe 3X what it is now. What is the
> impact/cost of setting max_fsm_pages at, say, 3M for an 8GB footprint?
> (3 x 8GB/8K)
Ok, so I see 40B per
This is a huge improvement over GBorg! I feel much more comfortable
with this than I ever did with GBorg. GBorg always seemed very
unfriendly and the crusty look and feel at first made me wonder how
legitimate it was as a source for serious projects. I realize now that
it housed some great p
Mark Harrison wrote:
I'm looking for feedback from anybody who has used pg in a
multi-threaded program, particularly one in which several
threads each open a database connection.
It's documented to work in that scenario, but I'm interested
in anybody who can share some real-world with that.
It wor
Mark Harrison wrote:
> I'm looking for feedback from anybody who has used pg in a
> multi-threaded program, particularly one in which several
> threads each open a database connection.
>
> It's documented to work in that scenario, but I'm interested
> in anybody who can share some real-world with
At some point in time, [EMAIL PROTECTED] (Tom Lane) wrote:
>
>> max_fsm_relations = 1000 and max_fsm_pages = 1.
>
>Also you doubtless need max_fsm_pages a lot higher than that. A
>conservative setting would make it as big as your whole database,
>eg for a 10Gb disk footprint use 10Gb/8K (some
"Ed L." <[EMAIL PROTECTED]> writes:
> 2) Would this low setting of 1 explain the behavior we saw of seqscans
> of a perfectly analyzed table with 1000 rows requiring ridiculous amounts
> of time even after we cutoff the I/O load?
Possibly. The undersized setting would cause leakage of disk
"Ed L." <[EMAIL PROTECTED]> writes:
> Sorry, I see that's *6B* per, so setting it to 3M ==> 18MB, which is trivial
> for the benefit. Any other concerns in setting this too high?
Not that I know of.
regards, tom lane
---(end of broadcast)
On May 7, 2004, at 12:43 PM, Mark Harrison wrote:
I'm looking for feedback from anybody who has used pg in a
multi-threaded program, particularly one in which several
threads each open a database connection.
It's documented to work in that scenario, but I'm interested
in anybody who can share some
On Friday May 7 2004 12:23, Ed L. wrote:
> On Friday May 7 2004 12:20, Ed L. wrote:
> > 1) I'm inclined to set this to handle as large a DB footprint as will
> > be in the coming year or two, so maybe 3X what it is now. What is the
> > impact/cost of setting max_fsm_pages at, say, 3M for an 8GB f
On Friday May 7 2004 11:25, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > No, our autovac logs the number of changes (upd+del for vac,
> > upd+ins+del for analyze) on each round of checks, and we can see it was
> > routinely performing when expected. The number of updates/deletes just
Mark Harrison wrote:
I'm looking for feedback from anybody who has used pg in a
multi-threaded program, particularly one in which several
threads each open a database connection.
It's documented to work in that scenario, but I'm interested
in anybody who can share some real-world with that.
I've do
"Ed L." <[EMAIL PROTECTED]> writes:
> No, our autovac logs the number of changes (upd+del for vac, upd+ins+del for
> analyze) on each round of checks, and we can see it was routinely
> performing when expected. The number of updates/deletes just far exceeded
> the thresholds. Vac threshold was
I was wondering what the best way is to store a file hash (MD5 or SHA1)
and make it primary key indexed.
I have seen some people storing the hexadecimal encoded MD5 in a
CHAR(32) but it may be a better idea to use a CHAR(16) without encoding
the string, but that may cause some problems.
What do yo
I'm looking for feedback from anybody who has used pg in a
multi-threaded program, particularly one in which several
threads each open a database connection.
It's documented to work in that scenario, but I'm interested
in anybody who can share some real-world with that.
Many TIA!
Mark
--
Mark Harri
On Friday May 7 2004 9:09, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > I guess the activity just totally outran the ability of autovac to keep
> > up.
>
> Could you have been bit by autovac's bug with misreading '3e6' as '3'?
> If you don't have a recent version it's likely to fail to
Dragan Matic wrote:
if exists (select * from sysobjects where id =
object_id(N'[dbo].[pp_fisk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pp_fisk]
GO
For instance, this is a valid script in Ms SQL, it will drop table
pp_fisk only if it exists, is there a way to do something
"Ed L." <[EMAIL PROTECTED]> writes:
> I guess the activity just totally outran the ability of autovac to keep up.
Could you have been bit by autovac's bug with misreading '3e6' as '3'?
If you don't have a recent version it's likely to fail to vacuum large
tables often enough.
Mike Hunter <[EMAIL PROTECTED]> writes:
> After a recent power failure, a program that uses a pgsql backend
> (netdisco) started to send me nastygrams.
Hmm. Try REINDEX on the index involved.
regards, tom lane
---(end of broadcast)
(Please CC me on any replies as I'm not on the list)
Hi,
After a recent power failure, a program that uses a pgsql backend
(netdisco) started to send me nastygrams. I tried the author's suggestion
of running a VACUUM FULL ANALYZE VERBOSE;, but it still sends me the
messages. The data in the dat
Hallo Uwe,
danke für deine ausführliche Erklärung. Das ist die Lösung für mein Problem.
MfG
Bastian
[EMAIL PROTECTED] ("Uwe C. Schroeder") wrote in message news:<[EMAIL PROTECTED]>...
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Bastian,
>
> warum die Tabelle nicht so aufbauen:
>
Thanks for your reply. I thought (perhaps erroneously) that there
wasn't any real difference between dropping an index then recreating
it, and just reindexing an index?
On Thu, 06 May 2004 23:00:25 +0200, Denis Braekhus <[EMAIL PROTECTED]> wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SH
Sorry I made a mistake, I saw docs for 7.4, because I use an other server
running that version.
So this won't work on 7.3.*.
Can I drop OID column painlessly? Does it lead to any problems?
Thank you,
-- Csaba
> -Original Message-
> From: 'Karel Zak' [mailto:[EMAIL PROTECTED]
> Sent: 2004.
On Fri, May 07, 2004 at 01:59:39PM +0200, Együd Csaba wrote:
> cygwin/7.3.4
> The doc contains the option but doesn't work - at least for me.
http://www.postgresql.org/docs/7.3/static/sql-altertable.html
The ALTER TABLE ... SET WITHOUT OIDS is in new in 7.4
Release 7.4 notes:
ALTER TABLE
cygwin/7.3.4
The doc contains the option but doesn't work - at least for me.
--Csaba
> -Original Message-
> From: Karel Zak [mailto:[EMAIL PROTECTED]
> Sent: 2004. május 7. 13:48
> To: Együd Csaba
> Cc: '[EMAIL PROTECTED] (E-mail)'
> Subject: Re: [GENERAL] Removing OIDs without recreate
>
32 matches
Mail list logo
