till haven't result,
> and backend still was eating my RAM. I know that this query is
> ugly and bad, but I think backend will reject such query at parsing.
>
The query is valid you should get more ram or rethink your query :-)
- Einar Karttunen
---(end
y that an index scan will improve the situation drastically.
Even more
so for you because the table seems to have very many rows in it.
- Einar Karttunen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
work with quite big bases (up to 10-20Gb). I am not
> sure now that Postgres will work with bases greater than 10Gb, what does All
> think?
>
> Thanks in advance, Ivan Babikoff.
>
In my experience postgresql has no problems with big databases. I have had several
pr
You should probably compile it with a better machine, then you can run it
in your low-end machine. Remember to specify the correct machine-type
flags for gcc.
- Einar Karttunen
---(end of broadcast)---
TIP 2: you can get off all lists at once with
It is by no means an answer to the problem but
should help if you just need things to work.
eg. export PATH=/usr/local/postgres/include:$PATH
replace /usr/local/postgres/include with the path to postgres.h
- Einar Karttunen
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the application is very simple
php might be better, but if it is very complex I think perl is better.
- Einar Karttunen
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
vacuuming server side, if the
application doesn't change a large amount of data.
- Einar Karttunen
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
so many that you should use a copy, try wrapping them in a
single transaction.
- Einar Karttunen
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
>
> Sincerely, Renaud THONNART
>
Have you performed a VACUUM [ANALYZE]? If you are inserting data in larger
patches consider using copy or dropping indexes. What version of pgsql are
you using? There used to be (if I remember correctly) a bug in 7.1 betas
that made the inserts
cript (as attachement) that does the inserting feel free to use
it. You need DBI and DBD::Pg to use it.
- Einar Karttunen
#!/usr/bin/perl
# Einar Karttunen 28.3.2001 <[EMAIL PROTECTED]>
# this file must be distributed under GNU GPL
use DBI;
use DBD::Pg;
print 'group
uld reference this view
I could simulate referencing parent and child tables easily.
What I have in mind is a hierarchy of persons all inheriting from a table
called person. Different kinds of persons have different attributes but
all have an id and name. What I want is that other tables could reference
ted by the installation. Anyone had the
same problem? Is there any way to get the db working? Because I
need outer joins I cannot use the 7.03.
- Einar Karttunen
12 matches
Mail list logo
