I wrote:
Robert Haas robertmh...@gmail.com wrote:
If you could send a revised patch, that would be great.
Attached. I put it in the same spot relative to the lock
acquisition that was used earlier in the function.
And version 3 which might actually work. [sigh]
-Kevin
***
Greg Stark gsst...@mit.edu wrote:
On Thu, Mar 31, 2011 at 11:33 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Greg Stark gsst...@mit.edu wrote:
your query does require reading all the data.
Huh? It requires reading all the data from at least *one* of the
tables.
The query he
Greg Stark gsst...@mit.edu wrote:
your query does require reading all the data.
Huh? It requires reading all the data from at least *one* of the
tables. I could conceivably be faster to read all the data from the
table with 23,980 rows and randomly pick out the necessary 33,768
rows from
Lawrence Cohan lco...@web.com wrote:
We have a huge performance issues in Postgres that surfaced due to
existing indexes not being used
This doesn't sound like a bug; it sounds like you haven't tuned your
server.
For starters, you should check out this page:
Lawrence Cohan lco...@web.com wrote:
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
[configuration advice]
If, after reading the above-cited page and tuning your server you
still have performance problems, pick one query to work on first,
and follow the step outlined here
Lawrence Cohan lco...@web.com wrote:
Please see updated attachment that includes the tables involved in
the simple query below and all their indexes.
Well, that rules out a couple common problems (comparisons between
different types and incorrect indexing).
We believe that the performance
Harry Rossignol harry...@comcast.net wrote:
I'm just a lowly end user. Bumping the default statistics target
or using ALTER TABLE SET STATISTICS has made large differences in
query performance on large tables.
The default has been bumped up in later versions, so that shouldn't
be as big a
Lawrence Cohan lco...@web.com wrote:
looks like we will need to change at least the two values below
and maybe play with work_mem to see if it solves our issues.
You will probably get better throughput by bumping up
shared_buffers to the recommended setting, but beware of stalls in
query
martin van leeuwen wrote:
PostgreSQL version: 9.0.2-1-win-x84
Operating system: windows 7 enterprise SP1
Description: pgadmin sql-query text pad doesn't work
Details:
The text input for sql query tool in pgadmin stopped working today
(26 mrch 2011) and was succesfully used the last time
YAMAMOTO Takashi wrote:
Description: SetRWConflict assertion failure
SerializableXactHashLock relocking in CheckTargetForConflictsIn()
seems racy to me.
You're right. The attached patch should fix the assertion you hit.
I will take a close look at the code above the patched area (for
Jonathan Brinkman j...@blackskytech.com wrote:
I guess EST is not DST-friendly?
EST stands for Eastern *Standard* Time, which is explicitly *not*
under Daylight Saving Time.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
Tambet Matiisen tambet.matii...@gmail.com wrote:
Pre-live database is restored from live database dump every night.
How is that done? A single pg_dump of the entire live database
restored using psql? Are both database servers at the same
PostgreSQL version?
So far the errors have been in
rajesh sri_rajesh_...@yahoo.co.in wrote:
replace the old data folder
FATAL: could not open file base/16519/PG_VERSION: Permission
denied
Previous connection kept
What user is running the postgres process? Who owns the
base/16519/PG_VERSION file and its ancestor directories?
-Kevin
Tambet Matiisen tambet.matii...@gmail.com wrote:
On 16.03.2011 17:09, Kevin Grittner wrote:
Tambet Matiisentambet.matii...@gmail.com wrote:
Pre-live database is restored from live database dump every
night.
How is that done? A single pg_dump of the entire live database
restored using
Tambet Matiisen tambet.matii...@gmail.com wrote:
For a few days I've been getting this error from my nightly backup
script:
Warning: pg_dump: SQL command failed pg_dump: Error message from
server: ERROR: found toasted toast chunk for toast value 260340218
in pg_toast_260339342 pg_dump:
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
On 08.03.2011 02:37, YAMAMOTO Takashi wrote:
i got the following assertion failure. given that availableList
is not empty and SxactGlobalXminCount == 0, i guess it was raced
with ReleasePredicateLocks.
Yeah, that's what it
Allan Registos allan.regis...@smpc.steniel.com.ph wrote:
When I press the SQL query, the whole pgadmin will close.
Although, it works previously.
You might have a better chance of getting the attention of the right
people if you post to the pgadmin-support list. Even then, you
probably need
Heikki Linnakangas wrote:
Here's what I had in mind. Can you review
The additions and modifications to the comments all look good to me.
I can see why you renamed one field and eliminated another; no
problem there. I'm really surprised, when you ignore those changes,
how little was needed
YAMAMOTO Takashi y...@mwd.biglobe.ne.jp wrote:
heap_fetch calls CheckForSerializableConflictOut without buffer
locked. it ends up an assertion failure in
SetBufferCommitInfoNeedsSave.
diff --git a/src/backend/access/heap/heapam.c
b/src/backend/access/heap/heapam.c
index
YAMAMOTO Takashi y...@mwd.biglobe.ne.jp wrote:
a seemingly wrong math in OldSerXidAdd makes it busy writing zeros
to pg_serial.
[patch]
Your fix looks correct to me -- we want to get from a SLRU segment
number to the first page of that segment, so SLRU_PAGES_PER_SEGMENT
is the right
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
Hmm, if I'm reading that function correctly, it makes sure that
when headPage 0 (which implies that the SLRU has not been used
since startup, right? )
No, look at the bottom of OldSerXidSetActiveSerXmin() -- cleanup of
segments
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
Sorry, I was not entirely clear. It clears all pages from the
start of the segment, up to the last currently active page, even
if the active region from tailXid to headXid only spans a couple
of pages somewhere in the middle of
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
I wonder if we should move the responsibility of truncating the
SLRU to checkpoint. At the moment, it's done in
OldSerXidSetActiveSerXmin(), while the callers are holding
SerializableXactHashLock in exclusive mode. While it'll
I wrote:
I think what we're protecting against is disk I/O at COMMIT time,
not transaction startup.
One more thought on this -- on a properly configured server, this
code should rarely be exercised unless there is a long-running READ
WRITE transaction. The delay, if any, would be on the
Tom Lane t...@sss.pgh.pa.us wrote:
Josh Berkus j...@agliodbs.com writes:
There is actually a time zone Navajo, which is a *separate*
time zone from US/Mountain. Ideas on how this happened?
It's not all that separate: per the Olsen database,
Link America/Denver US/Mountain
[rearranged to eliminate top-posting]
Nacho Mezzadra nachomezza...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Nacho Mezzadra nachomezza...@gmail.com wrote:
could not start server
PostgreSQL 8.3 started successfully
That looks like a packaging problem. The lines
Jonathan Brinkman j...@blackskytech.com wrote:
## I COULDN'T MAKE IT BREAK USING PSQL.
That's pretty solid evidence that the problem isn't in the
PostgreSQL server.
This didn't always happen, it just started happening on various of
my tables a maybe couple weeks or so ago. I think it is
MANISH GOYAL goyalmanis...@gmail.com wrote:
I have installed postgre on my computer ,but since morning i am
trying to connect to server through localhost
everytime it is showing me some error ?permission denied or
connection timed out ,i don't understand what is the reason?Please
tell me
Jonathan Brinkman j...@blackskytech.com wrote:
My default timestamps in my database all are +5 hours in the future
Can you copy paste actual statements and results?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
Jonathan Brinkman j...@blackskytech.com wrote:
createddatetime TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT now(),
What happens if you use TIMESTAMP WITH TIME ZONE?
Can you provide a more complete, self-contained example, like this?:
test=# drop table if exists show_ts_issue;
DROP TABLE
Nacho Mezzadra nachomezza...@gmail.com wrote:
could not start server
PostgreSQL 8.3 started successfully
That looks like a packaging problem. The lines starting with
uppercase letters appear to have come from the service script, not
PostgreSQL itself.
-Kevin
--
Sent via pgsql-bugs
muthu dbamu...@gmail.com wrote:
i want to change the max clients and max threads in pgbench..is it
possible in postgres...then how?
default is 1 thread and 1 client
http://www.postgresql.org/docs/current/interactive/pgbench.html
In the future, please post such questions to pgsql-general
muthu dbamu...@gmail.com wrote:
PostgreSQL version: 9.0.2
Operating system: unbuntu 8.0
Description:postgres query tuning
Details:
steps for postgres query tuning and postgres.conf files for 64gb
ram...
where i can recovery db using only data folder.
This is not a bug
Savita savita.ha...@gmail.com wrote:
PostgreSQL version: 8.3.5
I have a table with id as primary key.
When I ran query to get the ids which ends with B1
select id from table where id like '%B1'
does not return me any rows.
You might want to check all the bug fixes listed in the 8.3
Savita savita.ha...@gmail.com wrote:
When I ran query to get the ids which ends with B1
select id from table where id like '%B1'
does not return me any rows. Should it be not returning row with
id AB1? Is there known issue?
Oh, I did have one more thought after I posted -- what is the data
Andi Sielicki it-asieli...@t-online.de wrote:
message: database not exist
this is wrong, database always exist
version 9.0.1.1 make it right
We would need a little more information to do anything with this
report.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
Matt Zinicola wrote:
PostgreSQL version: 9.0.3
Operating system: Linux (Fedora 14, kernel 2.6.35-10-74), 64-bit
Description: Postgres dumps core upon a connection attempt
Details:
A simple compile from source and install (as per usual) on Fedora
14 yielded crashes of client applications
[Please don't top-post. Rearranged for clarity.]
Steve White swh...@aip.de wrote:
On 1.02.11, Tom Lane wrote:
Steve White swh...@aip.de writes:
It would be really nice to have a way to load script (especially
Python and Perl) from a separate file into a function body.
This seems like a
Steve White swh...@aip.de wrote:
On 1.02.11, Kevin Grittner wrote:
Steve White swh...@aip.de wrote:
Isn't the \i command a similar security hole?
That is run by a client program on a client machine.
Sorry I don't understand this remark.
The CREATE FUNCTION statement is parsed
Tom Lane t...@sss.pgh.pa.us wrote:
The usual procedure is to put the whole CREATE FUNCTION statement
into a file, which you can then send with \i. I'm not quite
seeing the point of having just the body in a file? It's not like
the body is typically useful to run as standalone code.
The
Steve White swh...@aip.de wrote:
I said that the script interpreter might do this...
The script interpreter runs on the server.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Steve White swh...@aip.de wrote:
On 1.02.11, Tom Lane wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Maybe some option for the \i command? \iq (for input quoted)
with automatic $$ quoting around what is read?
That way you could do something like:
CREATE FUNCTION yadda_yadda
Robert Haas robertmh...@gmail.com wrote:
Can't you already do it this way:
\set yadda `cat yadda_yadda.py`
CREATE FUNCTION yadda_yadda() returns text language plpythonu AS
:'yadda';
OK, that works. It sure ain't pretty, though.
Clever, but not pretty.
-Kevin
--
Sent via pgsql-bugs
Robert Haas robertmh...@gmail.com wrote:
I think this patch would only be adding to the confusion. When
PQgetResult() is called, we read enough data from the connection
to create and return one result object. It's true that this
doesn't necessarily detect an EOF, but IIUC calling
Murray S. Kucherawy m...@cloudmark.com wrote:
Please, at a minimum, add some documentation about it.
Current documentation at:
http://www.postgresql.org/docs/9.0/interactive/libpq-async.html
says:
| PQgetResult must be called repeatedly until it returns a null
| pointer, indicating that
Murray S. Kucherawy m...@cloudmark.com wrote:
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
What do you think would make this more clear?
So maybe something like this after the paragraph you cited would
help:
Note that after returning a PGresult object, PQresultStatus
Richard Baratta one__eighty__...@hotmail.com wrote:
Cannot connect to-- Localhost-5432-with my username being
postgres. I need this fixed immediately it is used for my
business. When I type in the password is says Fatal error or along
those lines.
We would need a bit more detail to be able
Peevee peeve...@yahoo.com wrote:
Select TableName from TestTableB LIMIT 1
ERROR: relation testtableb does not exist
Identifiers containing uppercase letters must be quoted.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
harshad sati_hars...@rediffmail.com wrote:
i m the beginner of postgreSQL database.and want to become expert
in this database.
is theer any certification courses for postgreSQL database
available?
Welcome to the world of PostgreSQL! However, this is clearly not a
bug report, so it
kapil kapil_bo...@yahoo.com wrote:
I have connected postgreSql with Atllassian products.
i receiving the follwing error.::
java.sql.SQLException: Connections could not be acquired from
the underlying database.
This doesn't sound like a bug, at least not a PostgreSQL bug. You
frank fr...@ros-i.com wrote:
WHERE upper(thisColumn) like $1
The function's plan is kept from one execution to another, and it
can't know what will be in the first parameter -- perhaps '%X%'? If
you build up the statement in a string and EXECUTE it, you might get
the desired behavior.
yiranwang wrote:
My Database's Name is BankAbc,it is not be backup.
How are you trying to do that? What happens? What messages are on
the console or in the log?
Please read this page and post a more complete report:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
Paul J. Davis paul.joseph.da...@gmail.com wrote:
After running many queries (millions) a connection will report an
error that the server has unexpectedly closed the connection.
What message are you getting? (Copy/paste is a good thing.)
What do you see in the server log at the time of
Eric Schwarzenbach subscri...@blackbrook.org wrote:
I've got a SELECT with a WHERE clause using IN against a BYTEA
column which works when I'm querying against the table directly.
However when I substitute an equivalent view in my query (a view
made of several inner joins which simply carry
Atul Kumar atul_ku...@persistent.co.in wrote:
My issue is, first time I am creating the table and inserting some
rows of data. After doing some logic going to delete that table .
I am observing application is getting hang while executing
statement.execute().
It's taking a long time to run
E.B Benoygopal wrote:
Description: Tables are not viewing through pgadmin
Since PostgreSQL itself is working as you expect, you might want to
ask on the support list for pgadmin: pgadmin-support
You might need to configure your search_path setting.
-Kevin
--
Sent via pgsql-bugs mailing
Mariana Chigir wrote:
We were looking for a contact telephone number on your web but it
is not there.
Please be so kind to contact us as soon as possible.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
http://www.postgresql.org/support/professional_support
-Kevin
--
Amrani sada...@hotmail.fr wrote:
I download poker tracker 3 and I can not install PostgreSQL 8.3
I have the error message :
Service 'PostgreSQL' Database Server 8.3 [pgsql-8.3] failed to
start. Verify that you have privileges to start system services.
This sounds like it is most likely a
Jemshir A.P jamsheer@gmail.com wrote:
PostgreSQL version: pgsql8
Operating system: Windows Server 2003
Description:Cannot start pgsql8 application with
Previleged account
In the application log of the server i can find the following
The server must be
tmoore wrote:
Running this test, a deadlock can be created without fail.
You haven't shown any evidence of a deadlock -- just blocking.
That's not at all the same thing.
postgres 16990 26837 44 11:20 ? 00:28:51 postgres: postgres uisdb
127.0.0.1(34405) idle in transaction
postgres
tmoore wrote:
The test is not doing any transaction based work, the write
functions just do sql insert, no begin commit blocks at the
application level.
Well something is starting transactions; otherwise you wouldn't have
a transaction sitting idle in transaction. Are you perhaps
tmoore wrote:
I'm a little tired. I just indicated autocommit false, that was
incorrect. Autocommit is true.
I would double-check that. As I said, what you showed us indicates
that something logging in through TCP on localhost is using
transactions, and not committing them when needed.
Euler Taveira de Oliveira eu...@timbira.com wrote:
Talking about your problem, are you sure you're not reaching
max_connections?
It also strikes me that from the minimal information given, it might
be possible that pid numbers or port numbers are wrapping around
before the OS is ready to
Mohammed Rashad mohammedrasha...@gmail.com wrote:
I am getting this error
* Starting PostgreSQL 8.4 database server
* Error: could not exec
/usr/lib/postgresql/8.4/bin/pg_ctl
/usr/lib/postgresql/8.4/bin/pg_ctl start -D
/var/lib/postgresql/8.4/main
Adrian Klaver adrian.kla...@gmail.com wrote:
On Monday 29 November 2010 7:02:46 am Mohammed Rashad wrote:
/etc/init.d/postgresql-8.4 start
Are you trying to start Postgres as root? If so Postgres will not
run as root,
you will need to start it as the Postgres superuser, usually that
is
Shafqat Ali wrote:
Operating system: XP Professional SP3
Description: C:\Program Files\PostgreSQL\8.3\Data is not
accessible.
From what little information you provided, this sounds more likely to
be a permissions issue under Windows security than anything else. If
you don't think it is,
Cristiano wrote:
Operating system: Linux
Description: pg_dump fail to find upper case table name
--table public.streetTypes
Linux is eating the quotes. Try:
--table public.'streetTypes'
While a bit confusing, this is not a bug in the code. Perhaps the
documentation should
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote:
Manual says (at the bottom of
http://www.postgresql.org/docs/8.4/static/app-pgdump.html):
To specify an upper-case or mixed-case name in -t and related
switches, you need to double-quote the name; else it will be
folded to
abraham camacho abrah...@cantv.net wrote:
PostgreSQL version: 8.0.0
Yikes. That was released almost six years ago and went out of
support last month. There are 26 maintenance releases since that
dot 0 release to fix bugs and security problems.
Sunil Vedd sunil@songas.com wrote:
PostgreSQL version: PostgreSQL 8.4
8.4.what? Please copy/paste the output from running:
select version();
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
Denis dolgalevde...@mail.ru wrote:
nextval('NameSeq')
Does it work if you specify?:
nextval('NameSeq')
Generally, when the parameter is a character string representing an
identifier you must include quotes to preserve the capitalization.
-Kevin
--
Sent via pgsql-bugs mailing list
Arturas Mazeika maze...@gmail.com wrote:
the shared buffers is set to 128M, and the working mem
is set to 1GB. We've got 16GB memory in total
Each connection can allocate work_mem memory, potentially multiple
times -- for multiple nodes in a query plan.
-Kevin
--
Sent via pgsql-bugs
Tom Lane t...@sss.pgh.pa.us wrote:
Here's a proposed patch, sans documentation as yet.
I see you took the surgical approach -- only a cast from a record to
a character string type is affected. I agree that will fix the
complaints I've seen, and I imagine you're keeping the change narrow
to
Merlin Moncure mmonc...@gmail.com wrote:
Trying to understand real world cases that this would
break...would the following now fail w/o explicit cast?
create type x as (a int, b int);
select f((1,2));
It already does:
test=# create type x as (a int, b int);
CREATE TYPE
test=# select
Tom Lane t...@sss.pgh.pa.us wrote:
What would be affected is something like
select text((1,2));
which you'd now be forced to write as
select (1,2)::text;
(or you could use CAST notation; but not text(row) or row.text).
Right. As far as I'm aware, there are currently
Tom Lane t...@sss.pgh.pa.us wrote:
3. Or, perhaps we could change recordDependencyOnSingleRelExpr so
that it generates a whole-table dependency on the target relation
even if there are no Vars in the expression. This would make it
act much more like the regular-query context that
expect, btw - so just ran it and let it
roll like any other.
Loaded up Amarok1 in Arch, where I use it for my musicdb, and found
that postgresql wasn't running that way. I tried to start it
manually, tried rebooting, etc. - nothing worked.
Kevin Grittner wrote:
Kim Garrendeda...@bjoernvold.com wrote
Jon Nelson jnelson+pg...@jamponi.net wrote:
If I saw this behavior ( a.b also meaning b(a) ) in another SQL
engine, I would consider it a thoroughly unintuitive wart
I think the main reason it has been kept is the converse -- if you
define a function b which takes record a as its only
Checkout from HEAD this morning, no modifications. Did make
distclean and fresh build to ensure no problems caused by mixed
build. 32 bit kubuntu on single drive dual core workstation. Fresh
initdb. Default configuration.
postgres=# create database bug;
CREATE DATABASE
postgres=# \c bug
You
Kim Garren deda...@bjoernvold.com wrote:
Received update to postgresql 9.0.1-2 yesterday
How? From where? What were you running before?
Once booted, I try to start it manually, with the following
result:
# /etc/rc.d/postgresql start
:: Starting PostgreSQL
[BUSY] server starting
Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kevin.gritt...@wicourts.gov writes:
Robert Haas robertmh...@gmail.com wrote:
I think if I had to pick a proposal, I'd say we should disable
#2 for the specific case of casting a composite type to
something else.
Well, then let's do
Satheesan K Nair supp...@shakthiinnovators.com wrote:
C:\pgsql\binpg_dump.exe -h dbserver -p 5432 -U streamline -F c -v
-f C:\backup\wrm_batch.backup -t wrm_batch -n Jay Jay Mills
Lanka (Private) Limited 16mar10
I don't know about Windows, but on Linux you would need apostrophe
quoting
Alan T DeKok al...@freeradius.org wrote:
the hard-code 10 could be USECS_PER_SEC.
To save others the time of checking, it's actually 100 in the
patch.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
Sekhar chakka sekhar.cha...@livialegal.com wrote:
We have installed Postgres 9.0.0 on ubuntu 10.04 LTS 64 bit
machine. It was working untill you restart the server. Once the
server is rebooted the database is not starting
Is there a service configured to start on reboot which runs it?
stagirus mam...@stagirus.com wrote:
JDBC driver does not convert boolean value (false/true) to
integers (0/1).
Can you mention which methods of which classes you would expect to
do this?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
[Moving the discussion to the PostgreSQL JDBC list, with a blind copy
to bugs. This doesn't sound to me like a bug, per se, but an
extension to the JDBC driver which may be a convenience to some
users. We're more likely to get the attention of the right group of
people on the JDBC list.]
Edoardo Serra wrote:
SELECT * FROM dummy ORDER BY string ASC;
string
100%
10.1
(2 rows)
I would expect the order of the results to be '100%', '10.1'.
Moreover, if I use the following dataset, I get the correct sorting
SELECT string, ascii(substr(string, 3, 1)) FROM dummy
missing chunk number chand.vi...@gmail.com wrote:
when i run my table in editor i faced this below error.
Ex: select * from ad_role
ERROR: missing chunk number 0 for toast value 525559 in
pg_toast_325765
** Error **
ERROR: missing chunk number 0 for toast value
Tom Lane t...@sss.pgh.pa.us wrote:
Yeah, exactly. I think that the current tradeoff is just fine.
If you want SQL-standard behavior, pick SQL-standard constraint
names, and there you are.
I see that as the crux if it -- the current implementation *allows*
standard-conforming behavior, even
LINO-ANTOINE PATY GISIBU lino_p...@mongenie.com wrote:
Hi! I am a user of one of your product; The Postgresql database
server in his version 8.3.
8.3.what? Obtained how?
No long time, after an electricity power interruption, I could not
start my database server
Which means you
Scott Wheeler wheels7...@hotmail.com wrote:
Can you tell me what the pg_stat_tmp file is used for?
It's not a file; it's a subdirectory. The statistics information is
periodically written to a file within that subdirectory when
PostgreSQL is running.
I concur with prior advice -- make sure
Ramachandran S nic.sr...@gmail.com wrote:
I have observed that if a table exceeds size (default
installation) 1 GB. The table when it exceeds 1 GB a file is
created say 1811(table) with 1811.1 and further records added are
insertted into this file. My Question if I remove the file 1811.1
[moving discussion to -hackers]
Michael Meskes mich...@fam-meskes.de wrote:
Kevin Grittner kevin.gritt...@wicourts.gov schrieb:
Marcelo Mas m...@atg.com.uy wrote:
Valgrind reports memmory leak when getting decimal data.
I wonder how much overlap there is between this and the patch
Marcelo Mas m...@atg.com.uy wrote:
Valgrind reports memmory leak when getting decimal data.
I wonder how much overlap there is between this and the patch for
fixing ECPG memory leaks offered by Zoltán Böszörményi three days
ago. There was much discussion about the dynamic UPDATE/DELETE
WHERE
Hitesh Bhambhani hitesh.bhambh...@asg.com wrote:
Could you give an example of what an 'extraordinary circumstance'
would be?
Normal vacuums will remove old tuples (versions of rows) which can
no longer be seen by any transaction, and make that space available
for re-use within the PostgreSQL
seol-don...@hti.hitachi-hitec.com wrote:
I tried to uninstall Postgresql. But, data folder was denied
to remove.
How? And how was it installed in the first place?
When I tried to remove data folder in 8.4 folder by force, my
computer shut down and startup automatically.
Tried to
Alex Hunsaker bada...@gmail.com wrote:
On Wed, Aug 4, 2010 at 11:04, Tom Lane t...@sss.pgh.pa.us wrote:
If we were a bit earlier in the 9.0 cycle I would suggest that
this confusion is a sufficient reason to drop the one-argument
form of string_agg. It's too late now though.
FWIW I think
Divyaprakash divyaprakas...@celstream.com wrote:
I am unable to create the databases after the successful
installation of postgresql. please help me as early as possible.
We need more information before we can be much help. Please read
this and post again on the pgsql-general list. It
Vimi vimmip...@gmail.com wrote:
How can i add field inbetween in the table while creating
This is not a bug; in the future please post such questions to
pgsql-general.
While the feature you're requesting is likely to appear in a future
release, current releases require that you create a new
Tizziano Perea tizzia...@gmail.com wrote:
PostgreSQL version: 8.2.17
Operating system: CentOS 5.4
Description:Error Trying to connec from Crystal Reports to
Sever
I,ve been install Crystal Reports 11 in a WinXP machine, and when
i tried to connect to
201 - 300 of 497 matches
Mail list logo