I'm building an appliance where I don't want my customers having to
tune postgresql in any way from the configuration when I install it. I
don't even want them to know it is there. Yet in my study of posgresql,
it seems that even conscientious use of a vacuum daemon or cron job in
vacuum's vari
On Tue, Dec 28, 2004 at 02:40:52AM -0800, Eric Brown wrote:
> I'm building an appliance where I don't want my customers having to
> tune postgresql in any way from the configuration when I install it. I
> don't even want them to know it is there. Yet in my study of posgresql,
> it seems that eve
On Mon, 27 Dec 2004, Peter Childs wrote:
> Tom Lane wrote:
>
> >Peter Childs <[EMAIL PROTECTED]> writes:
> >
> >
> >>2. I loaded out 7.4 database on via a dump and reload. Once done I keep
> >>getting errors when it trys to analyse (I'm using autovacuum) Nothing
> >>unsuall just a straght forwar
I'm trying to run query generated by an import script. postgresql 8
onder windows XP.
the file is about 42MB, i've opened this file by pgAdminIII and start
the query, it inserts data into 3 tables and after makes some update.
the time is too much and it hangs up without any commit.
any body know
dear all,
it is okay,
the import by psql is faster and quit, it is running now.
i've found an error in the query, it was the decimal separator that must be "."
and not ",".
now it's working.
thx to all
kasem,
-Original Message-
From: Nefnifi, Kasem
Sent: Tuesday, December 28, 2004 2:28
> "MvO" == Martijn van Oosterhout writes:
MvO> I'd suggest, use the autovacuum daemon, tune your FSM settings to what
MvO> you expect the load to be and maybe schedule a database-wide
MvO> REINDEX/VACUUM FULL regularly. We found doing it once a month was
MvO> enough to keep it tip-top over th
Peter Childs <[EMAIL PROTECTED]> writes:
> Further examination I orignally used by 7.4 backup (taken
> every 12 hours and well tested that they work under 7.4 anyway) rather
> than redumping using pg_dump 8.0. I have now dumped using pg_dump version
> 8.0 same problem. I dumped just the s
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
> Michael Fuhr napisał(a):
> > Why do you want the transaction ID? What problem are you trying
> > to solve?
> >
> I've already solved the problem - I found somewhere on the web a very
> simple C function, which returns transaction id. I need
Don't use OIDs for primary keys, please, please.
Use a Sequence instead, and replace your SELECT oid by SELECT
currval('sequence_name')
On Tue, 28 Dec 2004 15:44:56 +0100, Nefnifi, Kasem
<[EMAIL PROTECTED]> wrote:
dear all,
it is okay,
the import by psql is faster and quit, it is running n
that is right Pierre, i use an other field nl. id that is incremented auto.
Best Regards / Vriendelijke Groeten / Salutations Distinguées / Freundliche
Grüße !!!
Kasem NEFNIFI
AtosOrigin Belgium N.V.
Minervastraat 7
1930 Zaventem (Belgium)
Tel : +32(0)2 712 28 30
Fax : +32(0)2 712
Joachim Zobel napisaÅ(a):
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
Michael Fuhr napisaÅ(a):
Why do you want the transaction ID? What problem are you trying
to solve?
I've already solved the problem - I found somewhere on the web a very
simple C function, which returns transaction id.
Eric Brown <[EMAIL PROTECTED]> writes:
> My application is multi-threaded and I could care less about the concurrency
> afforded by MVCC. I'd rather just update the things in place and get less
> postgresql concurrency but more consistent long-running performance and disk
> space utilization.
Po
OK, that’s three so far that are
experiencing the exact same problem. Does anyone in the know have any
suggestions as to how this can be resolved?
Much thanks,
Peter
-Original Message-
From: Edgars Diebelis
[mailto:[EMAIL PROTECTED]
Sent: December
28, 2004 5:41
On 12/18/04 11:03 AM, "Scott Ribe" <[EMAIL PROTECTED]> wrote:
> All the recent OS X .x updates have replaced /etc/rc. For all I know they
> may always have done so, but of course prior to 10.3 we didn't have to
> modify /etc/rc directly.
You shouldn't be modifying /etc/rc directly anyway. Create
Title: Message
Please
check this: http://archives.postgresql.org/pgsql-hackers-win32/2004-12/msg00133.php
and report success/failure.
(I am
assuming the same problem. Please verify that the output in the postgres log is
the one about failure to attach to shared memory)
//Magnus
Wes <[EMAIL PROTECTED]> writes:
> On 12/18/04 11:03 AM, "Scott Ribe" <[EMAIL PROTECTED]> wrote:
>> All the recent OS X .x updates have replaced /etc/rc. For all I know they
>> may always have done so, but of course prior to 10.3 we didn't have to
>> modify /etc/rc directly.
> You shouldn't be modi
> You shouldn't be modifying /etc/rc directly anyway. Create a startup script
> in /Library/StartupItems, or /etc/mach_init.d. I believe the latter is new
> with 10.3 and is now the preferred method. Granted, modifying /etc/rc is a
> lot easier, but you pay for it later when an update wipes out
Hi all,
I need to to change an ip addres in a plpgsql function from aaa.bbb.ccc.ddd to
an sring containing "aaa bbb ccc ddd upload".
The following code does not work. It complaines about the replace line (or is
it the assignment?):
ERROR: syntax error at or near "replace" at character 1
CONT
You need to "replace" into something. Try
my_ipaddress_as_text := replace(my_ipaddress_as_text,''.'','' '');
Also, the concat operator is ||, not just one |.
Hope that helps!
On Tue, 28 Dec 2004 22:32:47 +0100, Joost Kraaijeveld
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I need to to change
19 matches
Mail list logo
