, but perhaps mysql is known to
fail in specific ways that a certain type of cleanup can repair. I'm not
aware of any such known corruption patterns in PostgreSQL.
--
Tod McQuillin
---(end of broadcast)---
TIP 6: Have you search
base'
does effectively the same thing as the above and saves you process
creation overhead on both systems.
--
Tod McQuillin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
column
will be the same in every row.
Where subselects get interesting is when you do a correlated subquery like
this:
select *, (select count(*) from table2 where table2.x = table1.y) as
sum_rows from table1;
--
Tod McQuillin
---(end of broadcast)---
> like base64, else you will have problem in INSERT/UPDATE queries.
If you encode with base64 you can use use varchar or text to store the
data. Then what is the point of the 'bytea' type?
Encoding/decoding base64 is a lot of overhead for large images (bot
; > )
My philosophy is, if you have any doubt at all just compile from source.
It does take a little longer, but you're guaranteed to get the right
binary for your system at the end.
You can find step by step instructions at
http://www.postgresql.org/idocs/index.php?ins
On Thu, 26 Apr 2001 [EMAIL PROTECTED] wrote:
> I have written all the script in a db.txt file, how to call the script from the
> file???
> In Oracle one can issue $ @filename and the job get done, whats the relative
> option in POSTGRES ???
\i filename
use \? for a complete l
be able to handle this pretty well.
The next question is, can we use it for a Usenet spool?
--
Tod McQuillin
figure
> or something that i could do to make it faster?
Hm, this will probably run the subquery for every row in the table. Try:
select keyword, count(keyword) from facts
group by keyword
having 1 <> count(keyword)
order by count(keyword) desc
Is this any faster?
--
Tod McQuillin
of the
query.
like,
SELECT prefix || '-' || lpad((random()*1)::int, 4, '0')::text as
"Phone Number" from phone_prefix order by random() limit 1;
--
Tod McQuillin
en the result is the null value.
(TXA refers to the table constructed from the summed column).
--
Tod McQuillin
4 03:21 postmaster -> postgres
I was not aware the binary would behave differently depending on the name
it was invoked as.
Thanks for straightening me out.
--
Tod McQuillin
wed
to use as much as SortSize kilobytes before it
starts to put data into temporary files.
Who is right?
--
Tod McQuillin
2
FROM v1 where date=SomeDateEnteredByTheUser;
--
Tod McQuillin
> matter how slow.
Well, assuming you've already optimised the queries to run as quickly as
possible, if you don't want the backend stealing cpu from other processes
then start postmaster with the nice command (man nice) to give it a lower
priority. It will still use just as much CPU time, but not at the expense
of other processes.
--
Tod McQuillin
14 matches
Mail list logo
