Joshua D. Drake wrote:
It's that time, after a wildly successful conference last October in
Portland, Oregon we are now beginning to ramp up for the East Coast 08
conference! The current plan is to host a two day conference of
Tutorials (new) and Talks on March 28th and 29th. The currently
desig
Francisco Reyes wrote:
Walter Vaughan writes:
I am not even sure this is a problem.
INFO: "data_import_customer2": scanned 3000 of 5033 pages, containing
84905 live rows and 0 dead rows; 3000 rows in sample, 142442 estimated
total rows
I don't believe it is a problem.
I t
I am not even sure this is a problem.
INFO: "data_import_customer2": scanned 3000 of 5033 pages, containing 84905
live rows and 0 dead rows; 3000 rows in sample, 142442 estimated total rows
Do I have some setting wrong?
---(end of broadcast)
Configuring autovacuum shouldn't be so hard.
:( I had a similar problem to this months ago, and I can't seem to fix it again
opentaps=# SELECT name, setting from pg_settings where name like '%stats_%';
name | setting
-+-
stats_block_
Raymond Hurst wrote:
I have a requirement of incorporating a database in a hard disk drive.
Well, back in the day there was a man called Dick Pick. The US Goverment had the
same request. They wanted a database incorporated into a hard disk drive, and
that's what they got. An operating system
Karl O. Pinc wrote:
I've created an INSERT rule on a view
but when I try to use the COPY command to
import data into the view it fails with.
cannot copy to view "viewname"
If the day was 24hours earlier, and Mr. Pinc was asking about some problem with
his "frail loop" view update, I would
Ben Trewern wrote:
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Perhaps the OP's posit should have been sent to pgsql-admin@pos
George Weaver wrote:
A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
W2K has been EOL'ed for quite some time. You might want to stress that to your
client. I don't know what you bill per hour, but their not-upgrading cost
savings should be negative and keep climbing.
Did y
Bradley Kieser wrote:
I am looking for a decent OpenSource CRM system that will run with
Postgres.
OpenTAPS the demo won't even work. And it's US-centric whereas we are in
the UK. A pity that it's so very much tied to the US as it could be very
good.
What actually didn't work with OpenTaps
Andrej Ricnik-Bay wrote:
I'm currently mucking around w/ importing TAB-delimited files;
how can I import empty values into a double precision field?
COPY complains about nothing between the TABS, about "\N"
and other variations, as being
"invalid input syntax for type double precision:"
For b
Rick Schumeyer wrote:
Completely off topic, (but not worth a separate post) I have been forced
to use a little bit of mysql lately...did you know that if you use
transaction and foreign key syntax with myisam tables, it does not
complain...it just silently ignores your requests for transaction
Vladimir Zelinski wrote:
I'm struggling to create a stored procedure. I
searched on Internet for several hours trying to find
a simple example, but didn't find anything. I saw
dozens of questions how to create a procedure without
any responses. I searched on postgreSql site and found
a topic "St
Shoaib Mir wrote:
pg_stat_all_table view should help you:
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
select last_autovacuum, last_autoanalyze from pg_stat_all_tables;
last_autovacuum | last_autoanalyze
-+--
|
...snip lot
I need to purchase a new server to put posgresql on that will be acting as the
DBMS server for Apache ofBiz soon. While googling around for performance tweaks
I saw this at http://revsys.com/writings/postgresql-performance.html
CPUs — The more CPUs the better, however if your database does not
[EMAIL PROTECTED] wrote:
Hello,
I am working on a project where we are converting from MySQL to
Postgres. I figured the easiest way would be to export the MySQL data
as CSV.
I dunno, but unless you don't really care about your data, I'd use something
that you have no chance of in your data.
pakt sardines wrote:
Hi all,
We're currently developing some large-scale software with the
intention of selling it (online and off-the-shelf). The version in
development uses Postgres to store stuff in a number of large databases.
Ignoring potential licensing issues for now, the big iss
Brandon E Hofmann wrote:
Does anyone recommend a Website Hosting Service that supports PostgreSQL
databases, Java, and Java Server Pages? Also does anyone recommend a
low budget security method to support logging into an application?
I've never had anything hosted there, but several people i
Alvaro Herrera wrote:
Walter Vaughan wrote:
I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem
to find where it placed admin82.sql, if in fact such a beast should have
been created with the initdb step.
I believe said admin81.sql corresponds to functions that were
I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem to
find where it placed admin82.sql, if in fact such a beast should have been
created with the initdb step.
Any ideas?
Google has zero indexed documents with admin82.sql in it's engine, and of course
all the instument
Enrico wrote:
HI,
I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres
installed.
Where can I have any info about?
Opimizing the FreeBSD kernel?
Obviouly you want to start with a machine with a much memory as you can afford,
as fast a disk subsystem you can afford, and as
Desmond Coughlan wrote:
Hi. As title. I'm getting a host of syntax errors, the last ten lines
of which are ...
NV_READ' undeclared (first use in this function)
/usr/ports/databases/php4-pgsql/work/php-4.4.4/ext/pgsql/pgsql.c:1937:
error: `INV_WRITE' undeclared (first use in this function)
Roman Neuhauser wrote regarding:
http://www.sema.org/main/semaorghome.aspx?id=56095
The firefox / thunderbird section should rather warn them to pay
attention to bugtraq. All those buffer overflows in libwhathaveyou
will make sure their single-user (root) KDE installations will need
I wrote an article that is in this month's SEMA News Show Issue that features
postgreSQL amoung other open source projects.
I had to write this article at a very high level (99% of the readers are car
nuts and mostly senior level management), but any positive mention of postgreSQL
should be a
Michael Fuhr wrote:
On Thu, Aug 17, 2006 at 03:27:26PM -0400, Walter Vaughan wrote:
ERROR: missing data for column "processed_timestamp"
The table you posted has 42 columns; at least one line in the file
doesn't have that many fields.
Yes, we didn't have the rig
For the past few months we have been experimenting with using MySQL with Apache
OFBiz. However, we are not sure that we can live with the performance.
We have a large dataset that we wanted to import into PostgreSQL, but it seems
to fail no matter what we do. We tried ever nuance we could to ge
25 matches
Mail list logo
