stat' command (or one of the numerous GUI
wrappers/replacements) to look at your open port list instead. That'll
show you what the OS thinks is in use.
--
Craig Ringer
build it only for the architecture you're actually
using. That probably goes for ia32 vs x86_64 as well as ppc32/ppc64 .
--
Craig Ringer
_backend_on_Windows
Alternately, and probably more easily, you can produce a self-contained
test case - in this case, probably a .sql file that when run on a newly
created blank database will result in the crash.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
ok for.
This is one of those places where transaction-scoped variables would be
really, really nice; a temp table is a bit of a clumsy way to do things.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
MERIC, though, rather than as floats.
I've been extremely happy with the NUMERIC data type when working with
monetary values. For scientific use I wish there was an equivalent type
with explicit accumulation of error so I knew how much of the value was
valid, but you don't need that for financi
e right DLLs for zlib, iconv, etc, not
different ones that happened to be on your PATH? You can check this
using Dependency Walker (depends.exe) from
http://dependencywalker.com/ , or by looking at the DLL linkage list
using Process Explorer from Sysinternals.
--
Craig Ringer
--
Sent via pgs
bles. It's a really, really
bad idea.
A better question might by "why on earth are you messing about with the
data directory when you don't understand what it does and how it works?".
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On 14/10/2009 2:29 PM, Scott Marlowe wrote:
> On Tue, Oct 13, 2009 at 11:24 PM, Craig Ringer
> wrote:
>>
>> A better question might by "why on earth are you messing about with the
>> data directory when you don't understand what it does and how it works?".
&
;m surprised you got anything but an error when trying
this. Perhaps it's not even seeing the WAL files from the old unrelated
cluster at all? If it did see them and try to use them I'd expect an
error reporting that the WAL archives don't make any sense for your
cluster.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 2009-10-19 at 07:18 -0700, Mitesh51 wrote:
> I am unable to restore data with the use of WAL files by following procedure.
>
> I have done following changes in postgres.conf to enable WAL archiving...
>
> archive_mode = on # allows archiving to be done
> archive_command = 'cop
ike lower-level networking issues. Is there any NAT
between client and server? What sort of network connects the two? Is
there any packet loss on the network? Is there any sort of firewall on
or between the client and server?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgres
greSQL specific terms.
> It is possible that server's performance cause the issue (server is too busy
> on that moment) ?
Highly likely given the additional information you've now provided.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nreadable in such situations, it
should mark the drive defective, set the array to read-only, and start
screaming for help. Way too much data gets murdered by RAID
implementations removing mildly faulty drives from already-degraded
arrays instead of just going read-only.
--
Craig Ringer
As you can see, EXPLAIN ANALYZE is reporting how long it took Pg to
execute the query. The psql \timing command reports how long the whole
process took, including psql reading the data from the postgresql server
and writing it out to the file on disk. Big difference!
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rectory and use the security tab to grant "full control" to the
postgresql user account then apply that change recursively you may be
able to start PostgreSQL.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mber function from C, but otherwise
it's generally fine so long as the C and C++ compilers default to the
same calling convention or you explicitly specify it on both ends.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
creating conversions ... FATAL: could not find function "alt_to_mic"
> in file "/opt/psb/db/pgsql/lib/cyrillic_and_mic.so"*
You might also want to examine cyrillic_and_mic.so by listing its
symbols. HP-UX uses the "nm" command for this, so:
nm /opt/psb/db/pgsql/li
or a functional index is
probably the best option.
If you decide for some reason that you really, really need the
concatenated fields stored in the table its self, you will need to use a
BEFORE INSERT ... FOR EACH ROW trigger to populate field `D'.
--
Craig Ringer
--
Sent via pgsql-genera
answer to this is an addition to the default valgrind
suppressions file, not any change to glibc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
exists on HPUX (or search for "ldd hpux" which will
probably tell you).
Are you connecting with the same host argument in both cases? In
particular, might you be connecting over a unix socket (the default)
with `psql', and tcp/ip with your application? That might be a clue.
Does th
for the DB server).
The pgxlogviewer page suggests that 8.1 support isn't present. The code
looks mostly abandoned (last updated in 2006) so you might have some
work ahead of you :S
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
most certainly the best
choice in this situation. A functional index can be used in situations
where a multi-column index doesn't apply, or where you need something
more complex, but here a multi-column index looks just ideal.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-ge
s as part of one
transaction. Your apps will see the update as atomic.
Assuming your data files are comma-separated:
BEGIN;
TRUNCATE TABLE data1, data2, data3;
COPY data1 FROM '/path/to/data1.csv' WITH CSV;
COPY data2 FROM '/path/to/data2.csv' WITH CSV;
COPY data3 FROM '/pat
to bind is function calls, and you can
handle any libpq-specific structures as opaque void pointers then it
shouldn't be too hard to just bind the function calls you need.
--
Craig Ringer
oo much data for that you could do a
multi-record INSERT (say insert ten records at a time). If that still
isn't good enough, then the network COPY protocol may be what you need.
I really doubt, though, that you need to do anything more than loop over
the array in your program and INSERT from it one-by-one within a
transaction.
--
Craig Ringer
e is, in fact, on the path you've specified: Is it
possible that your DLL links to other DLLs that are not on the
PostgreSQL server's path? If your DLL links to another that cannot be
found, that error message is the one you'll get.
Dependency walker (depends.exe) from http://depend
customer_curs;
... until there's nothing left and you can close the transaction or, if
you want to keep using the transaction, just close the cursor.
See:
http://www.postgresql.org/docs/8.4/static/sql-declare.html
http://www.postgresql.org/docs/8.4/static/sql-fetch.html
http://www.post
at two-phase commit is for - but I don't see how you
could use it in a trigger.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this file from the source tarball, probably because its name is so
> long. That could have happened to you --- if so, the recommendation
> is to find another tool to un-tar with.
I almost wonder if a `configure' test to detect this particular form of
source tree corruption would be helpf
r PL/PgSQL even with 8.4's
array_agg(...) and generate_subscripts(...) and given how many languages
seem to provide built-in support it seems to be an operation people need
quite a bit.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
y establishing another
connection to the server and calling pg_cancel_backend( ) at the SQL
level. This does, unfortunately, involve the overhead of setting up and
tearing down a connection and the associated backend.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
td::cout << std::dec << (unsigned int)(-1) << ' ' <<
std::hex << (unsigned int)(-1) << std::endl;
}
produces:
-1
4294967295
I don't know where you're getting the 1020, but 4294967295 is MAXUINT32
and
this.
So my first questions is: Can someone point me to a tutorial or posting
that shows how one might do that?
Failing that:
What data type should I use to store this?
What does the SQL look like to INSERT/SELECT the field?
Thanks,
Craig
column?
(FYI...most of my binary data would be only slightly bigger than what I
just pasted here. I am not storing Word documents or images, just some
encrypted strings of test that are not more than 100 characters long and
typically about 16 to 20.
Thanks,
Craig Boyd
On Thu, Sep 26, 2013 at
ork around it define
WIN32 in your project file.
I've added information about this, and the next error you mention, to
the wiki:
https://wiki.postgresql.org/wiki/Building_and_Installing_PostgreSQL_Extension_Modules
--
Craig Ringer http://www.2ndQuadrant.com/
Postgr
um.postgresql.org/ for RHEL / CentOS 6?
If you need to patch them, then you should be able to just "yum install
yum-utils", "yumdownloader --source postgres" to get the srpm, "rpm -i"
the srpm into your ~/RPMBUILD directory, and make any appropriate
modifications bef
that it's
possible. Users can CREATE CAST a weaker cast for the type, but:
* If there's already a cast for the type in the catalogs you may have to
hack the catalogs instead, as CREATE CAST will fail; and
* It's a convoluted process requiring wrapper functions for most simple
in
On 01/29/2014 02:01 PM, Tom Lane wrote:
> Craig Ringer writes:
>> I just want us to allow, by default, implicit casts FROM text (not TO
>> text) using the input function for all PostgreSQL's validated
>> non-standard types (and XML due to limited deployment of SQL/XML su
formation trough transparently.
Now think about Hibernate, Sequel ORM, Django ORM, ActiveRecord,
EclipseLink, OpenJPA, DataMapper, Entity Framework, EBean, TopLink,
iBatis/MyBatis, Doctrine, Propel, CakePHP, Zend, SQLAlchemy, ....
Wouldn't it be nice if we could find a solution to this user
On 01/29/2014 08:03 PM, Florian Weimer wrote:
> On 01/29/2014 09:07 AM, Craig Ringer wrote:
>
>> A challenge I've found when approaching this from the ORM side has been
>> getting people to care. The sentiment has tended to be along the lines
>> of: No other DBMS do
ell a user which SQLSTATE codes they can use without any risk that
PostgreSQL will later use that code for something else.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list
ole, but I am unable to find anything that even
begins to offer a clue. What command will show me this mysterious object,
please?
Thanks,
Craig
On Tue, Apr 22, 2014 at 3:02 PM, droletguillaume
wrote:
> hi Craig,
>
> I think this thread could help you:
>
>
> http://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it
>
> Sent from Samsung Mobile
>
As far
On Tue, Apr 22, 2014 at 3:06 PM, Raymond O'Donnell wrote:
> On 22/04/2014 20:47, Craig Libscomb wrote:
> > The following command:
> > DROP USER IF EXISTS jpate;
> >
> > generates the following output:
> > ERROR: role "jpate" cannot be dropped
On Tue, Apr 22, 2014 at 3:30 PM, Tom Lane wrote:
>
> Craig Libscomb writes:
> > The following command:
> > DROP USER IF EXISTS jpate;
>
> > generates the following output:
> > ERROR: role "jpate" cannot be dropped because some objects depend on it
On Tue, Apr 22, 2014 at 3:39 PM, Igor Neyman wrote:
>
>
> From: pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] On Behalf Of Craig Libscomb
> Sent: Tuesday, April 22, 2014 4:27 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Can
.
It's possible to use PL/PgSQL's 'EXECUTE' to use the parser to do the
work, but that's downright awful.
Am I missing something obvious, or is this something that'd be a good
new-developer TODO?
--
Craig Ringer http://www.2ndQuadrant.com/
P
x27;'||$1||''';' INTO retval;
RETURN retval;
END;
$$ LANGUAGE plpgsql;
CREATE FUNCTION
regress=> SELECT ohmygod(dummy) FROM test;
ohmygod
-
test ě
(1 row)
It'd be nice to expose this capability to users without requiring that
kind of horror.
Hence: ex
.
RAID won't help you if they all drop their caches if the power supply
throws a wobbly. That said, it's certainly good for the lifetime issues
especially if the units are upgraded or rotated out in phases.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent
Row compression would be interesting, but I can't imagine it not having
been investigated already.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
fields don't support compression.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing a few indexes in a tablespace that lives on a ramdisk. Usually
Pg's and the OS's cache management will do the job well, but if you know
more than them - say, that this index will always be really hot, or that
certain queries are more important than others and must be more
responsive - y
r database is in a good state.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
link to do the insert in another
transaction.
Personally, I'd enable PostgreSQL's CSV logging and then process the log
files, so you can include your logging info in the Pg logs. Using
logging tables will be way more hassle than it's worth.
--
Craig Ringer
--
Sent via pgsql-general
ent. SELECTs on partitioned
tables are not affected by triggers.
For INSERT, UPDATE and DELETE, where you're redirecting INSERTs into the
parent table into the appropriate partition, then speed might be a
concern. It probably doesn't matter. If you find it to be an issue, then
rather the
.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7;s not connected to the system you're recovering.
This message is very weird: "could not read from file "pg_clog/02CD" at
offset 73728: Success". What does 'ls -l pg_clog/' say?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ships in append-only ledger tables.
I use a mix of surrogate and natural keys, depending on the situation. I
see little point in surrogate keys for simple lookup tables, but find
them invaluable in audited tables with lots of foreign key relationships
that interact with other business systems.
27;re battling those, business needs change and the
database starts needing to accept people from other countries, who don't
have a US SSN and don't know what one is or what it looks like.
Tracking people/companies in databases are ideal candidates for
synthetic keying with a solid split/mer
se, it wasn't a big deal, but it just
goes to show that even the "obviously" globally unique isn't necessarily so.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
as fixed a
while ago, but it's an illustration of how something that seems like an
obvious natural key doesn't always stay one.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
transaction. Pg 9.0.4 enforces this, but it was still a bug in
whatever was trying to use nextval() in a read-only transaction before
9.0, Pg just didn't notice and warn you.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
ach is nice or easy, but nobody
has yet stepped up to write a unicode verifier tool that checks old
databases' text fields against stricter rules...
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oin a dblinked table with a
"local" table.
There isn't a good one for PostgreSQL, really.
Most people use replication tools like slony, londiste or bucardo to
replicate shared tables between databases, so each has a copy.
SQL/MED may improve the situation - at some point, possib
tyle. It'd help people who
want to use multiple databases on a machine and query between them,
though of course it'd do nothing for people who want to do inter-machine
or inter-instance queries.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ake a look and see.
I am presuming of course that one can query across schemas.
Yep, no problem at all with that, schema just let you categorize
tables/functions/etc into namespaces.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
rely on current_timestamp, random(),
etc? What about if their reliance is via a function? Is that just an
understood limitation of the cache, that it'll cache even queries that
don't really make sense to cache?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-gene
etc.
If you want more help from the people here, spend some of your own time
making an effort to more clearly explain what your app does, what your
needs are, what language & platform you use, etc etc etc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgre
infinite
intervals, the +infinity date, etc, so I have to represent unbounded
intervals with some distant future date, or use null. Neither option is
very palatable.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-genera
bottom of the
most recent log file.
Once you've done that, you'll have some idea what's wrong and what to do
next.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in a
hex editor, will be 0xEF 0xBB 0xBF .
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d Pg users who're experienced
developers volunteering their time on the mailing lists, unfortunately,
so Windows dev questions may not get as prompt/good answers.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
. It's also possible that
they were just wrong. All I'm saying is that you should investigate
carefully.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t that the slave could never, ever catch up because there just
wasn't enough bandwidth.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/19/2011 10:10 AM, Craig de Stigter wrote:
1. I'm assuming that the dump format can contain arbitrary sql commands,
so a pg_restore of this nature should be run under an untrusted account
in its own restricted schema. Can someone confirm that this is the case?
Correct. You
ot really.
It sounds like you might want to try to start Pg using pg_ctl via
runas.exe to run it as the postgres user account and see what error(s)
are produced.
See: http://technet.microsoft.com/en-us/library/bb490994.aspx
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general
ected by
list-price inflation to permit discounting. Insurers want to claim "95%
discounts!" so official list prices are massively, monsterously inflated
to make such discounts possible. Pity for you if you don't have insurance...
--
Craig Ringer
--
Sent via pgsql
On 20/05/11 13:00, Adarsh Sharma wrote:
> Thanks Craig,
>
> I spend some time on Memcahced and your explaination also helps.
> I think it is used only for applications where load is very high & users
> issue read only queries to the database.
Er, yes. You can't really
#x27;d like to have a
play, but I can't be bothered making up a sample data set or converting
yours by hand.
BTW, Personally I think you're usually better off using hstore in the
frist place ratherthan EAV, but you're probably already committed to an
EAV model.
--
Craig Ringer
--
Sent via pg
. all of which would've helped you ask a question with enough
information that someone could actually help you - or answer it yourself.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
n
information on which message is a reply to which other message. Nobody
expects you to know that and it's not important, but it *is* helpful to
know, because it means that creating a blank new message to the mailing
list will be more likely to be read than a reply to an unrelated to
rted alongside the postmaster to do the work. Right now, though,
you're better off doing things how PgAgent etc do it, that is
out-of-process via a regular Pg connection.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql
On 20/05/11 17:33, Adarsh Sharma wrote:
> Craig Ringer wrote:
>>
>> category_id Record_id fields
>> 7821 {Village:adasrpur, SOI:media, Heading:CM dies
>>
>
> Yes , but slight modification , I want Village, SOI Heading as column
>
ight
be suitable for you.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rkeley DB, SQLite or Firebird directly into
their program, rather than the other way around. PostgreSQL cannot be
embedded that way, it's not designed for that kind of use.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
twork chat, and the postgresql server logs (set to
log all queries) to compare the queries from the old and new clients and
see if anything was different. I'd also be comparing the ODBC DSN settings.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e and suggest you find
someone who _really_ knows what they are doing. Getting HA right is *hard*.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
p or fails.
It'd really help if you could show part of your postgresql logs from the
during restore.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
s this in the PgODBC documentation? It should be.)
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pooling vs admission control.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ead a comment immediately
beside the directive they're modifying.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/26/2011 09:48 PM, Tom Lane wrote:
Craig Ringer writes:
max_connections = 100 # (change requires restart)
# WARNING: If you're about to increase max_connections above 100, you
# should probably be using a connection pool instead. See:
# http://wiki.postgresq
pe in "postgresql replication" and the first result should be:
http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you ensure the
statistics used by the query planner are up to date. Since ANALYZE only
tests a sampling of records it does pretty much what you want, something
that it's not so easy to do in SQL.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
e even hinted at in a
single short paragraph without creating more confusion than it solves.
Something is needed, but perhaps it should just a be a pointer to the
documentation:
max_connections = 50
# Thinking of increasing this? Read http://some-documentation-url first!
--
Craig R
On 29/05/2011 4:39 PM, Craig Ringer wrote:
On 29/05/2011 10:44 AM, Edison So wrote:
Can anyone tell me that if the max_connections is above 100, the server
will use pooling instead?
No. PostgreSQL does not have any built-in connection pooling, that was
the point of the suggestion, to advise
able to find offerings from some of the professional
support people on this list:
http://www.postgresql.org/support/professional_support
or via Google.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
e
then it is *not* trustworthy without running ANALYZE tablename; first .
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
IIRC, newer versions of PostgreSQL print both queries.
You can use log_prefix to show the database, though I'm not sure it's in
8.1 .
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
you checked in the source code?
What version of libpq are you using, and what version of openssl is it
compiled against?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
601 - 700 of 1923 matches
Mail list logo
