This Postgresql can't see by itself what is the difference ?
> I don't want to check every character, this is stupid. I'd rather change
> the RDBMS.
Most every interface into postgresql has a 'quoting' mechanism that
will escape these characters for you. Check
* Lockhurst <[EMAIL PROTECTED]> [001212 07:54] wrote:
> What about using a Beowolf cluster. We are really interested in
> a online music stor but donot have the money. Well -- as per as
> bandwidth is concerned - GOOD LUCK. For us we are not planning to
> launch it in internet, only planning to s
aving to give up the cpu to
> allow other processes to run. With two cpu's, I believe one backend can
> camp out on a cpu forever as long as the other cpu doesn't get busy.
That's true, as long as there's no contention for the locks then it's
pretty cheap.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
an cause a lot of perf degredation(sp?) for the idle SMP case.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Jean-Arthur Silve <[EMAIL PROTECTED]> [001206 04:55] wrote:
> Thanks for your help
> pg_exec($dbh, "set enable_seqscan off;");
> seems resolve my problem...
>
> I look at the docs, but I didn't understand very well what is the use of
> this variable ?
run:
explain
with and without the opti
lyze " ?
2) do you have indecies on this table?
3) have you tried this: pg_exec($dbh, "set enable seqscan off;"); (*)
4) how can you expect help without going into a bit more detail about
how your table is set up and what the actuall query is?
(*) not sure on the syntax for that on
* Alfred Perlstein <[EMAIL PROTECTED]> [001123 15:04] wrote:
> * Alfred Perlstein <[EMAIL PROTECTED]> [001123 14:33] wrote:
> > * Timothy J Hitchens <[EMAIL PROTECTED]> [001123 13:35] wrote:
> > >
> > > That is 4 Million Queries per Second w
* Alfred Perlstein <[EMAIL PROTECTED]> [001123 14:33] wrote:
> * Timothy J Hitchens <[EMAIL PROTECTED]> [001123 13:35] wrote:
> >
> > That is 4 Million Queries per Second which is 14 Billion 400 Million per
> > hour.
> >
> > This may sound a little
on 400 Million per
> hour.
>
> This may sound a little big but this is what we will be launching on the 1st
> December 2000 using postgresql and php.
What platform is this going to be on? You will not be able to do
4 million queries per second with Postgresql on a PC platform.
--
-Alf
but I don't know it what way I can
> experiment with them?
>
> If somebody has some tips handy i'd like to hear them.
I have a gig of ram and use:
-B 32768
-o "-F -S 65534"
maybe if you halve those values...
you may also need to vacuum the database.
What OS are you running?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Hossein S. Zadeh <[EMAIL PROTECTED]> [001115 22:26] wrote:
> On Wed, 15 Nov 2000, Alfred Perlstein wrote:
>
> > * Serge Canizares <[EMAIL PROTECTED]> [001115 08:23] wrote:
> > >
> > > Of course, if someone sees a reason that RAID 5 would be bet
directory
>`/dmf/pkgs/postgres/7.0.3/postgresql-7.0.3/src/interfaces'
> gmake: *** [all] Error 2
>
Find 'ar' on your system, add it to your path.
-Alfred
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Paul Breen <[EMAIL PROTECTED]> [001115 07:46] wrote:
> Hello everyone,
>
[snip]
>
> Recently we have discovered that some records are missing from the main
> database table on the master box but are present in the table on the
> spare. We know its not a transaction problem (rolling back on ma
* Serge Canizares <[EMAIL PROTECTED]> [001115 08:23] wrote:
>
> Of course, if someone sees a reason that RAID 5 would be better than RAID 1+0,
> I'd appreciate an explanation!
Cost. :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart o
big table in reality.
You are only limited to 2 gigabytes in Linux, I don't know of any
other modern unix with that limitation.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ostgresql uses
with the -B option.
I'd go on but it wouldn't be worth the effort without hearing
what you've tried to do to get performance up.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Joel Pang <[EMAIL PROTECTED]> [001026 04:27] wrote:
> In psql, once I delete an entry, it's gone permanently. How do I disable
> such auto-commit behavior?
by beginning a transaction, just type:
"BEGIN;"
then with 'COMMIT;' (to commit) or 'ROLLBA
do a 'vacuum analyze' on the tables and
make sure you have proper indexing.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Gavin M. Roy <[EMAIL PROTECTED]> [001024 13:12] wrote:
> Am looking here:
> http://www.postgresql.org/devel-corner/docs/admin/runtime-config.htm
>
> but not seeing anything on shared memory. Do you know the configuration
> option for this?
-B
>
> Gavin
to stdout and not to pgserver.log (as I
> would want it).
You need to read your shell's manpage, try:
nohup postmaster -i >& pgserver.log &
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
# truncate/ftruncate routine
# or simply : cat /dev/null > logfile (my work)
killall -CONT postresql
you shouldn't loose any data that way.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Mitch Vincent <[EMAIL PROTECTED]> [000828 11:28] wrote:
> Can you move the logfile then touch the original file to create an empty
> one?
>
> *shrug* just an idea :-)
that won't work, the shell has attached the process's stdout/err to
the file, you can even remove the file and the server will
* The Hermit Hacker <[EMAIL PROTECTED]> [000828 11:19] wrote:
>
> can someone recommend on how to rotate the following log files without
> having to stop/start the server?
>
> postgres 85333 pgsql1w VREG 13,131084 995 762037
>/pgsql/logs/postmaster.5432.61308
> postgres 85333 pgsql
* Moses <[EMAIL PROTECTED]> [000821 17:20] wrote:
> HI,
> My name is Moses, I work as system admin in INDIA and I just got your ID
> when I was looking out for a solution on Semaphore Problem which I am facing
> currently. I will be greateful to u if you could help me out on this.
>
>I wo
24 matches
Mail list logo
