On Sep 19, 2006, at 23:57 , Merlin Moncure wrote:
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
(http://jobsearch.monster.c
On Oct 5, 2006, at 19:10 , Brian J. Erickson wrote:
And since it's a text file, can't someone fix it with $EDITOR?
I tried to edit the file, but I get the Input/Output error.
The recommendatation was to re-install the OS.
However, I DO NOT want to lose my database,
so I am tring to backup th
On Oct 10, 2006, at 10:34 , Bill Moran wrote:
I had an almost-gf once...
Me too!
-M
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Oct 13, 2006, at 11:47 , John D. Burger wrote:
Erik Jones wrote:
Forgive me if I'm way off here as I'm not all that familiar with
the internals of postgres, but isn't this what the genetic query
optimizer discussed the one of the manual's appendixes is supposed
to do.
No - it's not
On Oct 13, 2006, at 14:36 , Joshua D. Drake wrote:
Stephen Frost wrote:
* Alexander Staubo ([EMAIL PROTECTED]) wrote:
What formula did you use to get to that number? Is there a generic
way on Linux to turn off (controller-based?) write caching?
Just a side-note, but if you've got a pretty g
On Oct 16, 2006, at 16:17 , Madison Kelly wrote:
Alvaro Herrera wrote:
Jochem van Dieten wrote:
Scott Marlowe wrote:
While all the talk of a hinting system over in hackers and
perform is
good, and I have a few queries that could live with a simple
hint system
pop up now and again, I keep
On Oct 17, 2006, at 10:46 , Madison Kelly wrote:
Brian Mathis wrote:
I also am NAL, but I know enough about the patent system (in the
US) to know that ignorance *IS* a defense. If you are ignorant of
the patent, you only have to pay the damages. If you knew about
the patent and did it a
On Oct 19, 2006, at 10:30 , John D. Burger wrote:
cckramer wrote:
I have table for online chat system that keep messages sent
between users.
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into
table
within s
On Nov 2, 2006, at 14:02 , Glen Parker wrote:
louis gonzales wrote:
Hey Brian,
Yeah I had considered this, using cron, I just feel like that is
too dirty.
Actually I didn't see Andreas' post, can someone forward that?
I'm running this application on Solaris 9. Ultimately what I want
to k
On Nov 2, 2006, at 15:00 , Richard Troy wrote:
On Thu, 2 Nov 2006, AgentM wrote:
Just some commentary... This is exactly the sort of thing cron is
for. Duplicating that functionality in the RDBMS would be silly
IMO. I don't see why you could consider cron to be "dirty
On Nov 4, 2006, at 11:34 , Martijn van Oosterhout wrote:
On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
however, when i do this, my encoding is in UTF-8 via phpAdmin.
UTF8 is a part of UNICODE, but as i'm not sure on how many bits is
UNICODE,
how can i setup my local DB to UNI
On Nov 6, 2006, at 5:59 , Ben wrote:
Hello Folks,
i've been a postgresql user for a lot of years, mainly using it on
common x86 hw; now for a personal project of mine i wish to know your
opinion on porting it on an embedded platform.
I'm currently using PostgreSQL in my home automation project
On Nov 6, 2006, at 19:29 , Reece Hart wrote: On Tue, 2006-11-07 at 04:54 +0500, Talha Khan wrote: You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that dat
On Dec 7, 2006, at 6:00 , Albe Laurenz wrote:
Jasbinder Singh Bali wrote:
Whats the difference between a module and a bundle as i can
see while downloading DBI from CPAN website.
What exactly needs to be downloaded . I'm kind of not sure about it.
I have never heard of a 'bundle' in context
While this thread is tangentially interesting, due to the magic of
relational relationships, the point is really moot. If you are really
worried about various gender states in the future, just create a
table called "gender" and reference it and update it as necessary- done.
-M
On Aug 9, 2006, at 9:02 , Merlin Moncure wrote:
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
Assuming you are using less as your PAGER, then see:
http://www.greenwoodsoftware.com/less/#tite
One can add the -X option to your LE
Since the gapless numbers are purely for the benefit of the tax
people, you could build your db with regular sequences as primary
keys and then regularly (or just before tax-time) insert into a table
which maps the gapless sequence to the real primary key.
-M
---(
Just in case no one else has brought it up- 8.1+ supports 2PC and
savepoints, so one alternative would be to run your standard
insertion operations in a prepared transaction or savepoint block. If
you get so far as being able to prepare the transaction/complete the
savepoint block, you shou
On Aug 24, 2006, at 14:11 , Alvaro Herrera wrote:
Karen Hill wrote:
It would be really great if PostgreSQL supported SQL:2003 Window
functions. I know that oracle and sql server have them already,
so it
would make postgres competitive in that area. I know there is a
feature freeze for 8.
Perhaps you are trying to count business days? Those vary around the
world and you would certainly need a table to hold the holidays and
such. If you just want to count the number of non-weekend-days, then
get the interval as days and then it's a simple matter of math:
2*daysInterval/7+(day
On Aug 30, 2006, at 9:01 , Chris Mair wrote:
If you know what you're doing and you want to disable that
feature you need to recompile from source and disable the
uid checks in src/backend/main/main.c.
Unless you're working in the embedded space or some such thing,
I don't think it's a good id
On Aug 30, 2006, at 12:03 , Brandon Aiken wrote:
Unless it's a read-only database, I would never recommend using flash
media for an RDBMS.
Well, it's an embedded device, so you can pretty much be certain that
it's not storing sales information. If the flash goes belly up, then
the device
On Aug 30, 2006, at 13:58 , Brandon Aiken wrote:
I haven't got any numbers (or a USB stick I can test with at the
moment)
but USB is going to be a bottleneck for read and write performance.
Unless you're accessing very small amounts of data or running small
queries, I would expect performance
On Aug 30, 2006, at 16:11 , Martijn van Oosterhout wrote:
On Wed, Aug 30, 2006 at 01:54:56PM -0400, Robert Treat wrote:
Seems they are fast where it counts... namely getting a team of
developers on
top of the contest so they come out shining. Too bad people in this
community don't see the v
On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code
analysis was to use MySQL instead of PostgreSQL for the database.
"If you c
On Sep 14, 2006, at 21:25 , Bruce Momjian wrote:
I am not going to ask how you got to 135MPH.
Obviously he was running MySQL under the hood.
-M
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archive
26 matches
Mail list logo
