tried to install postgresql on vista ultimate, with uac turned off,( install
user belongs to administrators group)
tried the binary install and then the source install with mingw
the binary , wouldn't start service, install ended then and there .
the source with mingw gave me an error 2
is th
Hi all,
Do I need to enable the locale support or --enable_multibyte=EUC_TW is
good enough, I would like to be able to do sorting and issue LIKE
command. Anyone can share your experience?
TIA
Douglas
Where can I download the 7.1 snapshot?
Thanks
Douglas
On 9 Oct 2000 23:46:29 -0400, [EMAIL PROTECTED] (Tom Lane) wroth:
>"Ally" <[EMAIL PROTECTED]> writes:
>> However, I've read that Postgres 7.1 / 7.2 will accomodate larger row sizes
>> and was wondering i
Admin3.app remotely from a Mac
As stated I am fairly sure the cause was the upgrade of openssl as it started
to fail the next day:
Jun 16 05:18:25 qcmg-database1 yum[2965]: Updated:
openssl-1.0.1e-30.el6_6.11.x86_64
Douglas Stetner
Mobile 0474 082 019
UNIX - Live Free Or Die
sig
Hi all,
Looking for confirmation there is an issue with pg_dump failing after upgrade
to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux.
-bash-4.1$ pg_dump -V
pg_dump (PostgreSQL) 8.4.9
-bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz
pg_dump: Dumping the contents of table "mafs
>
> On 18 Jun 2015, at 02:06 , Tom Lane wrote:
>
> Douglas Stetner writes:
>> Looking for confirmation there is an issue with pg_dump failing after
>> upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux.
>
> Quick thought --- did you restart the Po
>
> On 18 Jun 2015, at 02:06 , Tom Lane wrote:
>
> Douglas Stetner writes:
>> Looking for confirmation there is an issue with pg_dump failing after
>> upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux.
>
> Quick thought --- did you restart the Po
Hello all,
I'm not sure if this is the correct list for extensions, if not please let
me know where this should be sent too.
I have a mid sized append only table that is read fairly infrequently and
contains 2 columns that contain on average about 0.5Kb and 2Kb of xml per
row. In an attempt to sa
rfering.
Brent
On Fri, Sep 2, 2016 at 11:07 AM, Tom Lane wrote:
> Brent Douglas writes:
> > What I have found however is that when I go to load my extensions I get
> > this error:
> > test=# create extension pg_zlib;
> > ERROR: incompatible library "/usr/loca
Thanks a lot Tom, it works as expected now. When reading the docs I must
have skipped to the code block without properly reading the sentence above.
Brent
On Fri, Sep 2, 2016 at 11:19 AM, Tom Lane wrote:
> Brent Douglas writes:
> > pg_zlib.c:24:1: warning: type specifier missing, de
Mike <[EMAIL PROTECTED]> writes:
> I see. Thank you for the elaborate response. I have a clearer idea of
> what is going on now. In designing my application I was thinking of
> storing pieces of my data as serialized python data structures into a
> binary field (no more than 15KB), while a friend
Joseph S <[EMAIL PROTECTED]> writes:
> My small gripes about Ubuntu are:
> 1) rpm, for all its faults, is still better than using apt
You *must* be joking. In Debian and Ubuntu, I've never had a tenth of
the dependency hell that you regularly hit with RPMs (though yum has
improved things somew
"Brian Mathis" <[EMAIL PROTECTED]> writes:
> Please don't start this. These issues are exactly why one should be
> looking at an ENTERPRISE OS for a server. Fedora, ubuntu, etc... are
> not enterprise OSes, and any discussion of such issues are certainly
> off-topic for this mailing list. An en
"D. Dante Lorenso" <[EMAIL PROTECTED]> writes:
> I need logic like "atomic test and set" or pop 1 item off the queue
> atomically and tell me what that item was.
>
> In my situation, there are a dozen or so machines polling this queue
> periodically looking for work to do. As more polling is occu
Devrim GÜNDÜZ <[EMAIL PROTECTED]> writes:
>> What I'm pondering here is that is the cluster able to keep the
>> postmasters synchronized at all times so that the database won't get
>> corrupted.
>
> Keep all the $PGDATA in the shared disk. That would minimize data loss
> (Of course, there is stil
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Scott Marlowe wrote:
>> On 8/14/07, john_sm <[EMAIL PROTECTED]> wrote:
>>> Hey guys, for an enterprise wide deployment, what will you suggest and why
>>> among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we
>>> can negotiate the
David Siebert <[EMAIL PROTECTED]> writes:
> I have a very old postgres server that I am trying to move the data off
> of. It is running 7.1 and has been trouble free for 6 plus years.
> I am trying to move the data base off to a server running 8.1.
> I have managed to back up the data using PG_Dum
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have recently used the MS SQL Server 2005 database, and found out that
> there is no mecanism where an execution plan can be reused between two
> successive calls to a view. This is only true with stored procedures.
>
> Is that also true with
"Bima Djaloeis" <[EMAIL PROTECTED]> writes:
> I have implemented a stored procedure that writes out the newest DB
> entry on insert, and combined it with a rule.
>
> 1) create function newcache() returns void AS 'newCache', 'newCache' language
> c;
> 2) create rule newcacherule AS on insert to cac
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> Not good because in that case pg_dump will generate code that can not run in
> 8.1 ... like :
>
> ALTER SEQUENCE ... OWNED BY
Dumps produced by version X of pg_dump have never been guaranteed to
load into earlier versions.
-Doug
--
Bob Pawley <[EMAIL PROTECTED]> writes:
> Following the examples in the docs I've come to this.
>
> I am attempting to restore the existing sql dump using
> psql -d PDW -f aurel.sql
>
> I am then asked for a password.
>
> I try every password that the computer knows with no success.
>
> Funny thing
kamiseq <[EMAIL PROTECTED]> writes:
> select into _id lastval();
> and is that safe operation, can I rely on lastval() that it will
> return value of id that was inserted before?
You want to use currval() with the sequence name.
> can it happened that other user will insert something betwe
João Paulo Zavanela <[EMAIL PROTECTED]> writes:
> Thanks, but I need configure password to connect to server!
> Now the pg_hba.conf is trust, I need change to passwd.
> Changing the file to passwd, I don't know how configure password to connect!
Set pg_hba.conf to 'trust', connect and use ALTER U
mgould <[EMAIL PROTECTED]> writes:
> We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4.
> One of the features that is really nice in ASA is the ability to add
> the attribute hidden to a Create procedure, Create function and
> Create trigger. Essentially what this does is encryp
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/31/07, Douglas McNaught <[EMAIL PROTECTED]> wrote:
>
>> The only bulletproof way to do this currently is to write all your
>> stored functions in C and load them as a shared library.
>
> Well, as I
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Nov 12, 2007 11:37 AM, Sam Mason <[EMAIL PROTECTED]> wrote:
>> And what's the performance hit of using native 64bit code? I'd guess
>> similar, moving twice as much data around with each pointer has got to
>> affect things.
>
> That's not been my
Thomas Finneid <[EMAIL PROTECTED]> writes:
> Hi
>
> I need to run latest Pg, i.e. 8.x, on a solaris 9 sparc machine, does
> anybody know of any prepackaged pg for that or any documentation that
> discusses compiling the source on such a machine. The Sun site only
> discusses how to do this in sola
"Robert James" <[EMAIL PROTECTED]> writes:
> 1.) Is there a way of separating, isolating, and sharing the shared data that
> will still allow FKs to it?
The only approach I know of would be to make all your customers use
independent schemas in one database, with isolation via appropriate
permissi
On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have trouble with my java application. Since i change the network
> configuration, the postgresql idle connections broken after 10 minutes. (i
> set authentication_timeout = 600 in postgresql.conf).
>
> My network:
>
> 192.168.1
On 11/27/07, Fernando Xavier <[EMAIL PROTECTED]> wrote:
>
>
> Hi, thanks for reply!
>
> No, my router don't have configurations for timeout connections..
Get a better router then. Something between your clients and the
database server is timing out those connections, and it's most likely
that box-
On 11/27/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Nov 27, 2007 12:33 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> > Get a better router then. Something between your clients and the
> > database server is timing out those connections, and it'
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
>
> Where will I find template1? When I look at the
> databases on the server, the only template I see is
> called "template_postgis". Most of the extra stuff I
> see in all my databases relates to geometry that I
> find in this template. When I
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> OK. A worry. How is template_postgis constructed?
> Is it just a handy reference to template1? Or does it
> exist independantly? I don't want to be dropping
> template1 only to find that breaking template_postgis.
All databases are separate
On 12/10/07, Ted Byers <[EMAIL PROTECTED]> wrote:
> So, how do I determine whether or not template1 really
> exists on my server and is a copy of template0 (as I'd
> infer from what I see in postgres) rather than
> template_postgis, and then modify things so that the
> default is the normal templa
On 12/12/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Regular database files need metadata journalling (data=writeback mount
> option for ext3). This is quite faster than full-blown journalling
> which is what you get with default ext3 mount options. WAL files
> (pg_xlog) do not need any kind
On 12/13/07, robert <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm trying to hack my inserts script from mssql to work with postgres
> 8.1.9 - I can upgrade if need be. I'm getting this error:
>
> psql -h localhost atdev < fuk2.sql
> ERROR: invalid byte sequence for encoding "UTF8": 0xe1204f
> HINT:
On 1/28/08, Dominique Bessette - Halsema <[EMAIL PROTECTED]> wrote:
>
>
>
> I dont really understand the question but here's an xml example of what is
> getting posted to postgres, and i'm trying to figure out how to do a
> connection.close() type of thing in it.
>
>
Postgres doesn't have a built-
I posted this question on dba.se (http://dba.stackexchange.com/q/65821/1396)
and was advised to try asking here.
If I'm using the Data Checksum feature (new to 9.3:
https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Data_Checksu
ms), and in the event of a checksum failure on a repl
Hi
Please forgive this question if it is naïve.
Would the following be practical to implement:
A btree-like index type that points to *pages* rather than individual rows.
Ie if there are many rows in a page with the same data (in the indexed
columns), only one index entry will exist. In
> The discussions at PGCon pointed out that with the posting-list
compression logic added in 9.4, GIN indexes are pretty close to this
already. Multiple items on the same heap page will typically only take one
byte of index space per item; but there is an identifiable entry, so you
don't get into
> > > To reduce complexity (eg MVCC/snapshot related issues), index entries
> > > would be added when a row is inserted, but they would not be removed
> > > when the row is updated/deleted (or when an insert is rolled back):
> > It's an interesting idea, but, how can you *ever* delete index ent
> in 9.4, GIN indexes are pretty close to this already
Do I understand correctly that BRIN indexes will be even closer to this?
Kindest regards
Jack
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 24 May 2014 22:46
To: Martijn van Oosterhout
Cc: Jack Douglas; pg
> If the values are perfectly clustered, the index is optimal because you
scan the minimal set of pages.
That's the bit I'm particularly interested in, as my plan would be to keep
the pages well clustered: http://dba.stackexchange.com/a/66293/1396
Do you see any blocker preventing BRIN being used
> Currently, one issue you're going to face is that brin doesn't rescan a
range to
> find the tighest possible summary tuple.
That's going to be an issue I think, thanks for mentioning it. We'd need
some sort of mechanism for achieving this without a complete REINDEX, even
if it only reset the min
I'm looking for a way where I can tailor DDL scripts for deployment with
environment variables.
Support I have a requirement to prefix table names with dev_ , fqa_, or prod_
I'd like to have a file for each env with their own unique settings - host,
dbname
Dev.sql
\set env dev
Fq
Visit/part*'
)
Runtime log
ERROR: syntax error at or near ":"
LINE 44: 'gphdfs://':filepath'/DimSiteVisit/part*'
I think I'm going to shift down to using shell features.
Thanks again for the help.
From: Steve Crawford [mailto:scrawf...@pinpointresea
Thanks in advance for thinking about my problem.
As I suspect you know, CA Erwin doesn't support Postgres or greenplum.
But they do support ODBC for reverse engineering.
When I reverse, Erwin executes the standard ODBC metadata queries for the
system catalog.
The process works fine, but I'm fin
Hi,
Design question.
Does it make a difference for a function to repeatedly update a temp table
verses the permanent table?
We are working in a data warehousing environment.
We have daily etl that's used to update our dimension table which has approx.
500k rows.
A dimension row holds all of the
Hi,
I have a dev and prod Greenplum system (4.2.2.4) that is based on PG 8.2.15
I have a function that's been working fine on dev, but when implemented in prod
had a syntax error.
I was easily able to fix by casting, but I can't see why the message didn't
show up on our dev machine.
I've review
I need a pl/pgsql function that will dump a table ddl so I can export the
definition to a file before I drop the object.
the psql \d command won't work, since it doesn't dump the table ddl, it just
lists the table's attributes and indexes.
I've got the function mostly working, but need help
build.
Thanks
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Wednesday, March 06, 2013 9:47 AM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general@postgresql.org)
Subject: Re: [GENERAL] FW: statement failure
On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas
mailto:douglas.lit
Thanks for the suggestion Adrian,
Unfortunately, my process is executing from psql, so to start pg_dump from
within psql is a bit challenging.
We have 1 instance where we start an OS process from a function, but it's new
territory for us.
My function is dumping everything but the ACL grant
al Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, March 07, 2013 12:19 PM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general@postgresql.org)
Subject: Re: [GENERAL] table dump function
On 03/07/2013 08:42 AM, Little, Douglas wrote:
> Thanks for the sugg
;ll need to restore from that backup and then
get pgbackrest (or another equivalent tool) up and running to protect
yourself going forward
--
{
"name" : "douglas j hunley",
"title" : "database engineer",
"email" : "douglas.hun...@openscg.com ",
"mobile" : "+1 614 316 5079"
}
LECT pg_stop_backup();"
>
>
> Should it use rsync or pg_dump instead?
>
> Thanks
>
> --
> World Peace Through Nuclear Pacification
>
>
--
Darren Douglas
Synse Solutions
dar...@synsesolutions.com
520-661-5885
-ar instead. The 'a' option invokes cp in
"archive" mode, which will preserve file permissions.
On Mon, Oct 9, 2017 at 9:49 AM, Darren Douglas
wrote:
> Ron:
>
> Here is an explanation that may help a bit.
>
> Your script is executing a PHYSICAL backup. A physica
On 1/31/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> I've noticed that by default postgres writes its log files read/write
> only by the postgres user.
>
> I have a nagios user I want to be able to analyse the logs.
>
> Is there a way to make postgres output them so they can be read by a
> group? O
> > Be aware that when 8.2.3 was released, 8.2 had only been out for two
> > months. There's another 11 months worth of accumulated bug fixes in
> > 8.2.6, including some that can cause the server to slow or crash. It's
> > not a difficult upgrade (no changes to the database) and you shoul
On 2/15/08, Tomás Di Doménico <[EMAIL PROTECTED]> wrote:
> Now I have the data into the UTF8 DB, and using graphical clients
> everything seems to be great. The thing is, when I query the data via
> psql, with \encoding UTF8 I get weird data ("NeuquÃ(c)n" for "Neuquén").
> However, with \encod
On 2/15/08, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> But you have to ensure that you build PostgreSQL on your desktop
> machine in exactly the same way as the RPM got built
> (integer_datetimes etc).
It'd probably be much easier to just install the -contrib RPM. :)
--
-Doug
---
On 2/15/08, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> LOG: could not receive data from client: Connection reset by peer
> LOG: unexpected EOF on client connection
> LOG: could not receive data from client: Connection reset by peer
> LOG: unexpected EOF on client connection
This means you
On 2/17/08, Maxim Khitrov <[EMAIL PROTECTED]> wrote:
> The simplest design would be to create two tables, one for nodes
> another for edges, and create a column for every possible property.
> This, however, is huge waste of space, since there will not be a
> single node or edge that will make use o
On 2/20/08, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Alternatively, is there a better way to streamline the duplication of a
> database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
(don't remember the exact syntax, but it'll be in the docs for CREATE
DATABASE). I think the 'createdb' progr
On 2/22/08, David Jaquay <[EMAIL PROTECTED]> wrote:
> When I do a ps -ef, in the command column, I see:
>
> postgres: postgres dbname 10.170.1.60(57413) idle
>
> I get all of this, except the "57413". What does this mean, and more
> importantly, how can I tie that number back to a connection that
On 2/22/08, David Jaquay <[EMAIL PROTECTED]> wrote:
> Yeah, kinda guessed that.
>
> So there's no way (that you know of) to, say, cast my JDBC connection object
> to something Postgresql'y and peer into its internals?
The docs and the source code for the PG JDBC driver are freely
available. Worst
On 3/4/08, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> On Tue, 2008-03-04 at 00:34 -0500, Tom Lane wrote:
> > Karl Denninger <[EMAIL PROTECTED]> writes:
> > > Anyone know where the magic incantation is to find the crypto
> > libraries?
> >
> > If the RPM layout is the same as Fedora
On 3/5/08, Erwin Brandstetter <[EMAIL PROTECTED]> wrote:
> The whole concept behind large objects is a bit off. Since we have
> TOAST tables, it is of limited use to store large objects away in a
> system table. It would be useful to have (additional) functions like:
>lo_import(text) RETURNS
On 3/6/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> I'm getting the back end closing connections early for some reason.
> Here is an exception report from my servlet. This first started
> happening with my instance of Trac, but now it's happening to my Java
> apps too. I hope someone can shed
On 3/6/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> Ok - lookint at the pg log, it appears that the server process is seg
> faulting :(. This might conceivably be my fault. I have 3 stored
> procedures written in C, but they've been on the server for months,
> and unless I didn't deploy them c
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> Well - I know that my stored proc is segfaulting based on a strace of
> postgresql. Don't know how that affects trac which isn't using that
> stored proc... the mystery continues. Either way I didn't get a
> corefile, and ulimit -a show I hav
On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote:
> No I'm not. Where would a core file be if there was going to be one?
They should appear in the data directory (e.g. /var/lib/pgsql/data).
> I'm not sure how I can tell if the ulimit applies to the running
> postmaster
>
> I am the postgres u
On 3/18/08, Vernon Van Zandt <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I keep getting the following error when attempting to establish a
> connection (from Perl):
>
> install_driver(Pg) failed: DBD::Pg object version undef does not match
> bootstrap parameter 2.2.2 at /usr/lib/perl/5.8/DynaLo
On Tue, Apr 1, 2008 at 7:56 PM, carty mc <[EMAIL PROTECTED]> wrote:
> In this case the updates that were made using dblink_exec are not getting
> rolled back in Database B.
And they won't be. dblink isn't transactional in that way. Your best
bet is to put all the data into one database and use
On Thu, Apr 3, 2008 at 2:34 PM, Dan99 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am having some troubles with a select group of tables in a database
> which are acting unacceptably slow. For example a table with
> approximately < 10,000 rows took about 3,500ms to extract a single row
> using the f
On Mon, Apr 7, 2008 at 9:51 AM, Dan99 <[EMAIL PROTECTED]> wrote:
> Unfortunately, I did not design this database (or the website for that
> matter) and am only maintaining it. As a result of the inexperience
> of the website designer, there are no indexes in any of the tables and
> it would b
On Thu, Apr 10, 2008 at 11:25 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 10, 2008 at 5:45 AM, CMOS <[EMAIL PROTECTED]> wrote:
> > hi,
> > i would like to get services of postgresql from inside the process (to
> > use it as a library and linking to it), i.e not having a separate
On Thu, Apr 10, 2008 at 3:46 PM, Roberts, Jon <[EMAIL PROTECTED]> wrote:
> I am moving from Windows to Solaris and I need pgcrypto and dblink.
> Where are these? I don't see anything in the configure that suggests it
> is even an option.
They're not handled by 'configure'. They are in the 'con
On Sun, Apr 27, 2008 at 2:06 AM, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> Do SQL statements inside of plpgsql functions get planned upon every
> execution, only when the function is first executed/defined, or something
> else entirely?
They are planned on first execution and the plan is cached
On Tue, May 13, 2008 at 11:52 AM, Fernando <[EMAIL PROTECTED]> wrote:
>
> Is it possible to do this?
>
> SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
You should be able to use CASE for this.
-Doug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
2008/5/13 Justin <[EMAIL PROTECTED]>:
> Your saying in Excel, Multiplication is not Commutativity??? that sends
> shudders down my back
The word you want in this case is "associative". Since floating point
math is not exact, sometimes the associativity (and other) properties
of some operati
On Sun, May 18, 2008 at 8:04 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> What is the effect of having nested functions all declared
> SERIALIZABLE?
>
> What if just the outermost is declared SERIALIZABLE?
SERIALIZABLE applies to the entire transaction, not to individual
function calls.
On Wed, Jun 18, 2008 at 8:44 PM, Albretch Mueller <[EMAIL PROTECTED]> wrote:
> ~
> I am developing a J2EE application that needs for users to only read
> DB tables. All queries are select ones, no updates, no inserts, no
> deletes for web users, so I keep this ro DB tables in certain
> partitions
On Thu, Jun 19, 2008 at 6:54 PM, Bill Thoen <[EMAIL PROTECTED]> wrote:
> I've got to load some large fixed-legnth ASCII records into PG and I was
> wondering how this is done. The Copy command looks like it works only with
> delimited files, and I would hate to have to convert these files to
> INSE
On Thu, Jun 26, 2008 at 7:12 PM, Adam Rich <[EMAIL PROTECTED]> wrote:
>
>> 1. I have heard of problems arising from compiling PostGreSQL (8.3) on
>> 64-bit
>> processors. What sort of problems am I likely to encounter and how
>> should I fix
>> them? We are will run Linux Redhat 5 on a Dell PE29
On Fri, Jun 27, 2008 at 11:52 AM, Benjamin Weaver
<[EMAIL PROTECTED]> wrote:
> Sorry, guys, for wasting bandwidth on this! You guys gave just the answer I
> wanted to hear. Sounds like there aren't any problems.
>
> Not knowing about such things, I was scared by the following quote. Perhaps
> bi
On Thu, May 28, 2009 at 4:14 AM, Simon Riggs wrote:
> Partition the table, then scan the correct partition.
If I do that, will Postgres figure out the "right thing" to do if the
parent table is queried instead? Also, what are the performance
implications then for doing queries that span all the
On Thu, May 28, 2009 at 10:24 AM, Scott Marlowe wrote:
> OTOH, if you've got it all sussed out, then ignore the request for more
> information.
I don't *know* if I have it "all sussed out", but I *do* know why
Postgres is doing what it is doing in this particular case. It's
assuming that the
On Thu, May 28, 2009 at 10:41 AM, Scott Marlowe
wrote:
> Note that in the OPs case I'd probably try testing things like turning
> off seqscan, or lowering random_page_cost. I'd also look at
> clustering on the index for the field you're selecting on.
I'm worried that turning off seqscan would d
On Thu, May 28, 2009 at 5:52 PM, Simon Riggs wrote:
>
> On Thu, 2009-05-28 at 15:03 -0400, Douglas Alan wrote:
>
> > The application in question is a kind of data warehousing thing (of
> > astronomical stars), and there's an ORM in the middle, so it's not
&
Scott Marlowe wrote:
> Douglas Alan wrote:
>> I'm worried that turning off seqscan would distort other queries.
>> (Remember, I don't have control of the individual queries. The
>> user of the application can specify all sorts of queries, and
>> there'
Scott Marlowe wrote:
> Douglas Alan wrote:
>> Okay -- no problem:
>>
>>set enable_seqscan = on;
>>explain analyze select * from maindb_astobject
>>where survey_id = 2
>>limit 1000;
>>
>>"Limit (cost=0.00..48.03 rows=1
I'd like to manually alter the statistics for a column, as for the column in
question the statistics are causing Postgres to do the wrong thing for my
purposes. (I.e., a Seq Scan, rather than an Index Scan.) If someone can
tell me how to achieve this, I would quite grateful.
Thanks!
|>ouglas
P.
r the specified column in the specified table.
|>ouglas
On Mon, Jun 1, 2009 at 2:20 PM, Douglas Alan wrote:
> I'd like to manually alter the statistics for a column, as for the column
> in question the statistics are causing Postgres to do the wrong thing for my
> purposes. (I.e., a S
On Tue, Jun 2, 2009 at 9:52 AM, Tom Lane wrote:
>
> delete from pg_statistic
> where (starelid, staattnum) in
> (select attrelid, attnum from pg_attribute
> where attrelid = 'my_relation'::regclass and attname = 'my_attribute');
>
> regclass knows about schemas and search paths, so stuff like
Hello,
We're migrating to Greenplum, and in our currently portfolio we base everything
on views.
In our prior system, we could alter tables and then refresh the views, but in
PG/greenplum most alters are blocked because of the dependent objects.
I understand that I can walk the pg_depends table
Andrew,
I think you want a full outer join. If I understood correctly, you want all
real data, plus all codes without data.
Doug
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Thursday, October
From: Little, Douglas
Sent: Tuesday, October 27, 2009 4:31 PM
To: 'pgsql-gene...@postgresql.org.'
Subject: Pgadmin support for writing files or psql \copy command
Hi,
I have a script I'd like to submit from pgadmin that needs to export query
re
Hi
Related to this post: http://dba.stackexchange.com/q/50693/1396
Would it be a major change to allow the `returning` clause of `insert` to
return values that are *not* inserted? It seems you can already do so for
literals (and perhaps that should be made explicit in the docs here:
http://
day + 10 hours 5
minutes'::interval hour to minute;
interval
------
3 years 2 mons -1 days +10:05:00
(1 row)
Warm regards
Jack Douglas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm working a string parser. Is there a user module that expands the set of
string functions?
Doug Little
Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz
Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax
312.894.5164 | Cell 847-997-
1 - 100 of 365 matches
Mail list logo
