[GENERAL] PQexec(), what should I do for the "NULL in command" problem?

2007-11-12 Thread jason
T INTO ('t', 'abc\0abc'); Does anyone know something about this? How can I insert a record which has some NULLs in data filed? Best Regards, Jason ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] PostgreSQL 8.2.3

2010-11-10 Thread Jason
Hi - I'm trying to find where I can download PostgreSQL 8.2.3. I've looked on the PostgreSQL website but I do not see version 8.2.3 specifically. Any help would be appreciated. Thanks, Jason -- View this message in context: http://postgresql.1045698.n5.nabble.com/Postgr

Re: [GENERAL] PostgreSQL 8.2.3

2010-11-10 Thread Jason
t are introduced. 8.2.3 was previously approved. Getting a newer version of PostgreSQL approved would probably take time that we do not have given the time-critical nature of our effort. Is 8.2.3 still available anywhere on the PostgreSQL site? I couldn't find it. Thanks, Jason -- View this

[GENERAL] My Slow query.

2005-08-24 Thread Jason
speciesPercent1 speciesCode2 speciesPercent2 PL 10 Sp11 P Sp NULL NULL So the 1,2.. in the colum names comes from the ORDER_NUMBER. I might be able to use the contributed crosstab function. Any ideas or comments? Thanks, Jason

[GENERAL] When an index and a constraint have the same name...

2007-01-30 Thread jason
quires it HINT: You may drop constraint rs_pkey on table report_specification instead. Is there some name-spacing trick I can use to selectively drop the index or the constraint in a way that postgres (using v8.1) will let me get away with it? Thanks, Jason ---

RE: [GENERAL] trying to move from MySQL

2000-11-20 Thread Jason
Thanks Tom for your emails and persistence to help me going. I'm eager to see what this database can do for my business now. :) Jason

[GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Jason
On Mon, Nov 27, 2000 at 02:56:59PM -0700, Roberto Mello wrote: > > PHP does not have a scheduling facility? AOLserver (the web/application > server that powers AOL) has had such facility (and many many others for > db-backed websites) since 1995. ns_schedule_proc. > http://www.aolserv

[GENERAL] Web Hosting That Supports PostgreSQL

2001-05-11 Thread Jason
r the development of my site, not production, so that's why I'm looking at a cheap solution. Anyone have any recommendations? Thanks. Jason ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] help with serial type

2001-04-26 Thread Jason
Hi , I'm a postgreSQL newbie. I have a table called "atable" that has the columns: title varchar(20) name varchar(20) id serial if I do: INSERT INTO TABLE atable VALUES('SQL1','Jason') the 'id' gets updated with a new number automatically. I then la

RE: [GENERAL] Upcoming 6.4 release issues

1998-11-03 Thread Jason
Try setting the environment variable `CXX' to `"gcc -O3"' (If you are using `gcc'). For example `CXX="gcc -O3" ./configure'. If you use this you don't nead to have libg++ installed! -Jason. -Original Message- From: dustin sallings [mailto:

[GENERAL] Different dB dir

1998-07-15 Thread Jason
/pgsql/DBNAME Is this possible? And if so, how? I am running PostgreSQL 6.3 on a Sparc 20. Thanks in advance. -Jason.

RE: [GENERAL] Performance

1999-03-30 Thread Jason
Database is vacuumed nightly. Matter of fact, it was vacuumed just prior to the start of the update! -Jason. -Original Message- From: K.T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 30, 1999 2:35 PM To: Statistical Solutions; [EMAIL PROTECTED] Subject: Re: [GENERAL] Performance

[GENERAL] Flexability.

1999-11-22 Thread Jason
Maybe sell it to O'Reilly. Anyway. Pg is an fantastic db in my opinion. -- . . Jason C. Leach .. University College of the Cariboo ... [EMAIL PROTECTED] .. http://www.ocis.net/~jcl . The Search for Extraterrestrial Intelligence from Home: http://setiathome.ssl.berkeley.edu

[GENERAL] regclass and format('%I')

2015-03-13 Thread Jason Dusek
| %I | "select" {name} | %L | 'select' {name} | %s | select {regclass} | %I | """select""" {regclass} | %L | '"select"' {regclass} | %

Re: [GENERAL] regclass and format('%I')

2015-03-14 Thread Jason Dusek
‘%I’ should do nothing. On 13 March 2015 at 12:42, David G. Johnston wrote: > On Fri, Mar 13, 2015 at 12:18 PM, Jason Dusek wrote: >> >> Hi All, >> >> The difference in how format handles `regclass` and `name` seems like an >> inconsistency: >> >>

Re: [GENERAL] regclass and format('%I')

2015-03-14 Thread Jason Dusek
On 14 March 2015 at 09:17, David G. Johnston wrote: > On Saturday, March 14, 2015, Jason Dusek wrote: >> It honestly seems far more reasonable to me that %s and %I should do >> the exact same thing with regclass. My reasoning is as follows: >> >> ‘%I’ formats a someth

Re: [GENERAL] regclass and format('%I')

2015-03-19 Thread Jason Dusek
o determine whether or not to quote. Introducing the behave I describe in an intuitive way would require some kind of type-specific handling in format(). I'm not sure what the cost of this is to the project, but David makes the very reasonable point that imposing the burden of choosing between `%s` and `%I` opens up the possibility of confusing vulnerabilities. Kind Regards, Jason Dusek

[GENERAL] Joins between foreign tables

2015-06-08 Thread Jason Dusek
in general, either.) Best Regards, Jason Dusek ​

Re: [GENERAL] Joins between foreign tables

2015-06-08 Thread Jason Dusek
p); It would stand to reason that the IN list could be pushed down to the foreign server; but this query’s performance is no better than the direct join between table_on_server1 and table_on_server2. Best Regards, Jason Dusek ​

[GENERAL] There can be only one

2015-10-11 Thread Jason Dusek
Consider a table of providers, for which one is the default. For example, payment providers: CREATE TABLE payment_via ( iduuid PRIMARY KEY, provider text NOT NULL, keys hstore NOT NULL DEFAULT '' ); Here we store together the name of the provider — medici, paypal —

Re: [GENERAL] Hierarchical Query Question (PHP)

2015-10-30 Thread Jason O'Donnell
ia' --<< substitute me > union all > select m.taxon, m.parent_id > from hier, gz_life_mammals m > where m.parent=hier.taxon > ) > select tax_rank(parent_id), >count(*) num_of_desc > from hier > where parent_id is not null > group by parent_id > order by parent_id;"; > > Thanks. > > -- Jason O'Donnell Crunchy Data Solutions

Re: [GENERAL] How to search a string inside a json structure

2015-11-02 Thread Jason O'Donnell
> > I guess postgre should traverse though each json structures while finding > the string. > > Thanks > -- Jason O'Donnell Crunchy Data Solutions

[GENERAL] client_min_messages and INFO

2016-06-22 Thread Jason Dusek
reverse of LOG? Kind Regards, Jason Dusek

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Jason Dusek
With regards to write amplification, it makes me think about about OIDs. Used to be, every row had an OID and that OID persisted across row versions. https://www.postgresql.org/docs/9.5/static/runtime-config-compatible.html#GUC-DEFAULT-WITH-OIDS Would reintroducing such a feature address some of

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-30 Thread Jason Dusek
On Thu, 28 Jul 2016 at 01:18 Gavin Flower wrote: > On 28/07/16 17:52, Jason Dusek wrote: > > With regards to write amplification, it makes me think about about > > OIDs. Used to be, every row had an OID and that OID persisted across > > row versions. > > > > >

[GENERAL] SERIALIZABLE and INSERTs with multiple VALUES

2016-10-11 Thread Jason Dusek
=# INSERT INTO with_pk VALUES (2), (2) ON CONFLICT DO NOTHING; ERROR: could not serialize access due to concurrent update =# END;ROLLBACK How are these two transactions different? Kind Regards, Jason Dusek ​

Re: [GENERAL] SERIALIZABLE and INSERTs with multiple VALUES

2016-10-11 Thread Jason Dusek
tion_deferrable │ on default_transaction_isolation │ serializable ​ On Tue, 11 Oct 2016 at 13:00 Kevin Grittner wrote: > On Tue, Oct 11, 2016 at 2:29 PM, Jason Dusek > wrote: > > > I notice the following oddity: > > > =# CREATE TABLE with_pk (i integer PRIMARY KEY); > > CREATE TA

[GENERAL] Large empty table, balanced INSERTs and DELETEs, not being vacuumed

2016-10-21 Thread Jason Dusek
? Kind Regards, Jason Dusek ​

[GENERAL] HeapTuple to JSON -- composite_to_json()?

2016-01-21 Thread Jason Dusek
to convert a HeapTuple to a Datum? Best Regards, Jason Dusek ​

Re: [GENERAL] HeapTuple to JSON -- composite_to_json()?

2016-01-21 Thread Jason Dusek
heap_copy_tuple_as_datum looks promising… http://doxygen.postgresql.org/heaptuple_8c.html#abfa9096cd7909cb17a6acfdc7b31b7ad

[GENERAL] Automatic install on windows

2007-06-25 Thread Jason Long
I have a client that wants a disaster recovery plan put into place. What is the easiest way to do a hands free install of postgresql on a window box? Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.supernovasoftware.com

Re: [GENERAL] recovery_target_time ignored or recovery always recov ersto end of WAL

2007-07-03 Thread Jason Buberel
LOL. Thats what i get for running configure and make with PG_HOME set to my 8.1.4 install. With that fixed i will start probing my WAL archives now. -jason --- Original Message --- From: Tom Lane <[EMAIL PROTECTED]> To: "Jason L. Buberel" <[EMAIL PROTECTED]> S

[GENERAL] interaction with postgres defined types in custom c functions

2007-07-17 Thread Jason Nerothin
et its internals. But I'm guessing that's not the appropriate way to do it... -- Jason Nerothin Programmer/Analyst IV - Database Administration UCLA-DOE Institute for Genomics & Proteomics Howard Hughes Medical Institute ===

[GENERAL] su: adduser: command not found mac osx

2007-09-14 Thread Jason Nerida
I've done everything I can find related to this error including su - instead of su useradd instead of adduser but nothing is helping, is there anyone out there using bash on mac os who knows how to fix this? Thanks, Jason ---(end of broa

[GENERAL] RPATH issue with libpq on Solaris 8 (gcc)

2007-11-06 Thread Jason Testart
I'm interested in some guidance on how to best deal with the following issue. I'm building postgres-8.2.5 on Solaris 8 SPARC, using a gcc built (not by me) for our environment. We have an old home-grown software distribution/configuration management system that arranges shared-objects and bi

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-30 Thread Jason Topaz
ented documentation has a tendency to skimp on the reference material and leave big gaping holes, in my experience. I like the reference focus of the existing PostgreSQL manual very much. -- Jason Topaz [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Linux

2010-11-05 Thread Jason Long
I use Centos for production and Fedora for development and I am very happy with both. Especially Centos as I have never had an update break anything. On Fri, 2010-11-05 at 09:50 -0400, David Siebert wrote: > I would say that if you pick any of the big four you will be fine. > CentOS > Ubuntu Serv

[GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
I currently have Postgres 9.0 install after an upgrade. My database is relatively small, but complex. The dump is about 90MB. Every night when there is no activity I do a full vacuum, a reindex, and then dump a nightly backup. Is this optimal with regards to performance? autovacuum is set to t

[GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
the default. -- Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.octgsoftware.com HJBug Founder and President http://www.hjbug.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
On Mon, 2010-11-08 at 13:28 -0800, John R Pierce wrote: > On 11/08/10 10:50 AM, Jason Long wrote: > > I currently have Postgres 9.0 install after an upgrade. My database is > > relatively small, but complex. The dump is about 90MB. > > > > Every night when there is no

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
On Mon, 2010-11-08 at 13:28 -0800, John R Pierce wrote: > On 11/08/10 10:50 AM, Jason Long wrote: > > I currently have Postgres 9.0 install after an upgrade. My database is > > relatively small, but complex. The dump is about 90MB. > > > > Every night when there is no

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote: > On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote: > > I currently have Postgres 9.0 install after an upgrade. My database is > > relatively small, but complex. The dump is about 90MB. > > > > Every night when

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2010-11-08 Thread Jason Long
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote: > On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote: > > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote: > >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote: > >> > I currently have Postgres 9.0

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2011-02-28 Thread Jason Long
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote: > On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote: > > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote: > >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote: > >> > I currently have Postgres 9.0

Re: [GENERAL] Full Vacuum/Reindex vs autovacuum

2011-02-28 Thread Jason Long
On Mon, 2010-11-08 at 16:23 -0700, Scott Marlowe wrote: > On Mon, Nov 8, 2010 at 3:42 PM, Jason Long wrote: > > On Mon, 2010-11-08 at 14:58 -0700, Scott Marlowe wrote: > >> On Mon, Nov 8, 2010 at 11:50 AM, Jason Long wrote: > >> > I currently have Postgres 9.0

[GENERAL] comma vs cross join question

2011-04-08 Thread Jason Long
I recently upgraded to JBoss AS 6.0.0.Final which includes a newer version of Hibernate. Previously the Postgres dialect was using a comma, but now is is using cross join. In order do to the migration I had to override the cross join operator to a comma in HIbernate so it would generate the same

[GENERAL] Count for pagination

2011-04-08 Thread Jason Long
rds for that page in an optimized fashion? I have no problem using a widow query or a Postgres specific feature as my app only runs on Postgres. -- Thank you for your time, Jason Long CEO and Chief Software Engineer BS Physics, MS Chemical Engineering http://www.octgsoftware.com HJBug Founder

[GENERAL] Count for pagination

2011-04-08 Thread Jason Long
The main search screen of my application has pagination. I am basically running 3 queries with the same where clause. 1. Totals for the entire results(not just the number of rows on the first page) a. <300 ms 2. Subset of the total records for one page. a. 1-2 sec 3. Count of the tot

Re: [GENERAL] comma vs cross join question

2011-04-08 Thread Jason Long
On Fri, 2011-04-08 at 14:45 -0400, Tom Lane wrote: > Jason Long writes: > > I am using 9.0.3 and the only setting I have changed is > > geqo_effort = 10 > > > One of the joins is a view join. > > Ah. The explain shows there are actually nine base tables in th

[GENERAL] pg_largeobject high overhead

2014-06-04 Thread Jason Newton
deal with fallout if any. I'd appreciate any insights, -Jason

[GENERAL] pg_largeobject high overhead

2014-06-04 Thread Jason Newton
deal with fallout if any. I'd appreciate any insights, -Jason

Re: [GENERAL] pg_largeobject high overhead

2014-06-04 Thread Jason Newton
ever parameters needed being runtime specifiable to make this more efficient / higher utilization. I may experiment with some custom builds in the future just to see how it goes. -Jason

[GENERAL] Overlapping ranges

2014-06-18 Thread Jason Long
I have a large table of access logs to an application. I want is to find all rows that overlap startdate and enddate with any other rows. The query below seems to work, but does not finish unless I specify a single id. select distinct a1.id from t_access a1, t_access a2 where tstzr

Re: [GENERAL] Overlapping ranges

2014-06-18 Thread Jason Long
On Wed, 2014-06-18 at 18:08 -0600, Rob Sargent wrote: > On 06/18/2014 05:47 PM, Jason Long wrote: > > > > I have a large table of access logs to an application. > > > > I want is to find all rows that overlap startdate and enddate with any > > other rows.

[GENERAL] unique index on embedded json object

2014-09-21 Thread Lee Jason
ucts tables because sku is not unique in this case. I tried to create a unique index like below, but it failed. CREATE UNIQUE INDEX product_sku_index ON products( (data->'bags'->'sku') ) Any suggestions, please? Thank you. Thanks, Jason

Re: [GENERAL] Syncing an application cache with xmin

2013-02-03 Thread Jason Dusek
2013/2/3 Tom Lane : > Jason Dusek writes: >> The idea would be, to store information about the last XID in >> the last sync and search for XIDs committed since then upon >> reconnecting for sync. Perhaps `txid_current_snapshot()' >> preserves enough informatio

Re: [GENERAL] date_trunc to aggregate values?

2013-02-04 Thread Jason Dusek
2010-07-07 > 01:45:00 cfc closed a2 tsoil_sctsoil_avg1_sc 20.47 > 20.463133545 > > I was tying to get two records out of this set, with the 'avg" column > representing the mean of the first and last four of each 15 minute records. > &

[GENERAL] Analyzing the types of prepared statements

2013-03-16 Thread Jason Dusek
I wonder if there's a better way. I'd prefer to be able to run the analysis step on a DB without changing it. -- Jason Dusek pgp // solidsnack // C1EBC57DC55144F35460C8DF1FD4C6C1FED18A2B -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Analyzing the types of prepared statements

2013-03-19 Thread Jason Dusek
2013/3/19 John DeSoi : > On Mar 16, 2013, at 8:30 AM, Jason Dusek wrote: >> However, it is not clear to me at this juncture how to get the >> return type for a statement, given its text. Preparing and >> looking it up in pg_prepared_statements will retrieve the >>

[GENERAL] Problem with left join when moving a column to another table

2013-06-20 Thread Jason Long
I am having some problems moving a column to another table and fixing some views that rely on it. I want to move the area_id column from t_offerprice_pipe to t_offerprice and then left join the results. When I have only one table I get the correct results. area_id is currently in the t_offerpric

Re: [GENERAL] Problem with left join when moving a column to another table

2013-06-20 Thread Jason Long
/* where (pwoa.id is not null and pbt.id is not null) or (pwoa.id is null and pbt.id is null) */ order by it.id; /***/ On Thu, 2013-06-20 at 12:29 -0700, David Johnston wrote: > Jason Long-2 wrote > > I am having some proble

[GENERAL] Easiest way to compare the results of two queries row by row and column by column

2013-06-20 Thread Jason Long
Can someone suggest the easiest way to compare the results from two queries to make sure they are identical? I am rewriting a large number of views and I want to make sure that nothing is changes in the results. Something like select compare_results('select * from v_old', 'select * from v_new')

Re: [GENERAL] Problem with left join when moving a column to another table

2013-06-20 Thread Jason Long
On Thu, 2013-06-20 at 15:37 -0700, David Johnston wrote: > Jason Long-2 wrote > > David, > > > > Thank you very much for your response. > > Below is a script that will reproduce the problem with comments > > included. > > > > > > &

Re: [GENERAL] Re: Easiest way to compare the results of two queries row by row and column by column

2013-06-20 Thread Jason Long
Thank you. I will give it a try. I have never used WITH before. Thank you for the tips. On Thu, 2013-06-20 at 16:05 -0700, David Johnston wrote: > Jason Long-2 wrote > > Can someone suggest the easiest way to compare the results from two > > queries to make sure the

Re: [GENERAL] Problem with left join when moving a column to another table

2013-06-20 Thread Jason Long
On Thu, 2013-06-20 at 16:22 -0700, David Johnston wrote: > Jason Long-2 wrote > >> Jason Long-2 wrote > > > > > > There is a unique constraint on the real price table. I hadn't thought > > of how I will enforce the constraint across two tables

[GENERAL] Imperative Query Languages

2017-07-04 Thread Jason Dusek
rite_drink FROM employee JOIN department USING (department) WHERE department.name == "infosec" The only language I can think of that is vaguely like this is Fortress, in that it attempts to emulate pseudocode and Fortran very closely while being fundamentally a dataflow language. Kind Regards, Jason ​

Re: [GENERAL] Imperative Query Languages

2017-07-04 Thread Jason Dusek
s a more recent and widespread example -- though not encompassing an entire language -- of something that has an imperative form while being declarative under the hood. Scala's for comprehensions -- more or less monad comprehensions --are another. With regards to Spark, I assume for comprehensions are an important part of the interface? Kind Regards, Jason >

Re: [GENERAL] Imperative Query Languages

2017-07-04 Thread Jason Dusek
; Declarative Query -> Imperative Plan Fortress is rather the same, since it translates imperative to functional to assembly. Kind Regards, Jason

Re: [GENERAL] Imperative Query Languages

2017-07-05 Thread Jason Dusek
> What are some alternative interpretations of this query? Are you referring to which rows are candidates for locking? Or the order of locking? Kind Regards, Jason ​

Re: [GENERAL] Imperative Query Languages

2017-07-05 Thread Jason Dusek
this way, I thought I’d write to ask you all if you had seen any. Kind Regards, Jason ​

Re: [GENERAL] Imperative Query Languages

2017-07-11 Thread Jason Dusek
They said it couldn't be done... dandl schrieb am Di. 11. Juli 2017 um 06:58: > From: pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] On Behalf Of Merlin Moncure > > > It's probably of broader interest to consider some sort of "more > relational" > > language tha

[GENERAL] full vacuum really slows down query

2008-06-04 Thread Jason Long
I have a query that takes 2 sec if I run it from a freshly restored dump. If I run a full vacuum on the database it then takes 30 seconds. Would someone please comment as to why I would see a 15x slow down by only vacuuming the DB? Reindexing does not help, and a full vacuum was run just prior

Re: [GENERAL] full vacuum really slows down query

2008-06-04 Thread Jason Long
maybe someone can help me out. Joshua D. Drake wrote: On Wed, 2008-06-04 at 17:02 -0500, Jason Long wrote: I have a query that takes 2 sec if I run it from a freshly restored dump. If I run a full vacuum on the database it then takes 30 seconds. If you run it a second

Re: [GENERAL] full vacuum really slows down query

2008-06-04 Thread Jason Long
uot; -> Seq Scan on t_state popipe1_1_ (cost=0.00..330.83 rows=5727 width=15) (actual time=0.087..8.880 rows=5732 loops=3174)" "Filter: (NOT spec)" "

[GENERAL] Full vacuum really slowing query down

2008-06-05 Thread Jason Long
I have a query that takes 2.5 sec if I run it from a freshly restored dump. If I run a full vacuum on the database it then takes 30 seconds. Would someone please comment as to why I would see over a 10x slow down by only vacuuming the DB? I am using 8.3.1 -- Sent via pgsql-general mailing l

[GENERAL] full vacuum really slows down query

2008-06-05 Thread Jason Long
I have a query that takes 2 sec if I run it from a freshly restored dump. If I run a full vacuum on the database it then takes 30 seconds. Would someone please comment as to why I would see a 15x slow down by only vacuuming the DB? I am using 8.3.1 -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] full vacuum really slows down query

2008-06-05 Thread Jason Long
Thanks for the advice. I will keep playing with it. Can someone here comment on EnterpriseDB or another companies paid support? I may consider this to quickly improve my performance. Scott Marlowe wrote: Have you run analyze on the tables? bumped up default stats and re-run analyze? Best way

[GENERAL] ON DELETE CASCADE Question

2013-11-04 Thread Jason Long
I would like for corresponding records in t_a to be deleted when I delete a record from t_b. This deletes from t_b when I delete from t_a, but not the other way around. I am unable to create a foreign key constraint on t_a because this table holds records from several other tables. I added a simp

[GENERAL] Queries with more than 1692 characters hang

2014-02-26 Thread Jason McKellar
n querying this specific server. The query I'm making is "select 'll';" where "l" is repeated to make the query 1692 characters long including the spaces and keywords before the semi-colon. Any idea what happened? Thanks, Jason

[GENERAL] 'tuple concurrently updated' error when granting permissions

2014-02-28 Thread Jason Daly
multiple concurrent grants to a role. We're using the latest version of postgresql (9.3) in the context of an AWS RDS. Should I enter a bug report, or can someone convince me that we should single-thread this part of our app (or work around it somehow)? Please respond to jasond...@trimblegeospatial.com -Jason

Re: [GENERAL] 'tuple concurrently updated' error when granting permissions

2014-03-03 Thread Jason Daly
why we took the approach we did. Now I have discovered 'ALTER DEFAULT PRIVILEGES' which will allow me to remove these concurrent permission grants - I only need to exec one ALTER DEFAULT PRIVILEGES command when the schema is created. Much obliged, Jason On Sun, Mar 2, 2014 at 6:09 AM, T

[GENERAL] Identifying old/unused views and table

2011-09-27 Thread Jason Long
I have an application with a couple hundred views and a couple hundred tables. Is there some way I can find out which views have been accessed in the last 6 months or so? Or some way to log this? I know there are views and tables that are no longer in used by my application and I am looking for

Re: [GENERAL] Identifying old/unused views and table

2011-09-29 Thread Jason Long
On Wed, 2011-09-28 at 08:52 +0200, Guillaume Lelarge wrote: > On Wed, 2011-09-28 at 09:04 +0800, Craig Ringer wrote: > > On 09/28/2011 04:51 AM, Jason Long wrote: > > > I have an application with a couple hundred views and a couple hundred > > > tables. > > > &g

[GENERAL] Any was to prevent a join if no columns are selected from a view?

2011-09-29 Thread Jason Long
I started an application around 5 years ago using Hibernate and writing my queries in HQL. The primary search screen has many options to filter and joins many tables and views. As the application grew the SQL Hibernate is generating is out of hand and needs optimization. As with other parts of t

Re: [GENERAL] Any was to prevent a join if no columns are selected from a view?

2011-09-30 Thread Jason Long
On Thu, 2011-09-29 at 22:54 -0600, Ben Chobot wrote: > On Sep 29, 2011, at 4:57 PM, Jason Long wrote: > > > > > I thought I had read somewhere that Postges could ignore a join if > > it > > was not necessary because there were no columns from the table or > >

[GENERAL] Rules, Windows and ORDER BY

2012-08-23 Thread Jason Dusek
og- -structured storage in Postgres. The window functions make, alas, no use of indexes. -- Jason Dusek pgp // solidsnack // C1EBC57DC55144F35460C8DF1FD4C6C1FED18A2B EXPLAIN (COSTS FALSE, FORMAT YAML) SELECT * FROM kv WHERE k = ... AND realm = ... ORDER BY at LIMIT 1

Re: [GENERAL] Rules, Windows and ORDER BY

2012-08-24 Thread Jason Dusek
2012/8/23 Tom Lane : > Jason Dusek writes: >> I have a simple table of keys and values which periodically >> receives updated values. It's desirable to keep older values >> but, most of the time, we query only for the latest value of a >> particular key. > >

[GENERAL] PQfformat question and retrieving bytea data in C

2012-08-29 Thread Jason Armstrong
-- 30da00090132420520203137323030 This is the data I'm expecting to get back. Is the '00' (third byte) causing the problem? The data looks the same at a certain place (ie it starts with the same byte 30, then the C code has 22 bytes whereas the db hex dump has 7 bytes, then

Re: [GENERAL] PQfformat question and retrieving bytea data in C

2012-08-30 Thread Jason Armstrong
t, so I changed bytea_output to 'hex', and DBD::Pg is also happy now (I also read that the hex format is more efficient). -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to startup the database server?

2012-12-19 Thread Jason Ma
ile. Hope anybody can help me. Thanks. -- Best wishes, Jason Ma

Re: [GENERAL] How to startup the database server?

2012-12-19 Thread Jason Ma
there must be somebody has the same problem with me. Any suggestions. Regards, Jason 2012/12/19 Adrian Klaver > On 12/19/2012 06:06 AM, Jason Ma wrote: > >> Hi all, >> I am a freshman of PostgreSQL, My env: PG 8.4 on CentOS,I follow the >> document in the offical

Re: [GENERAL] How to startup the database server?

2012-12-19 Thread Jason Ma
Hi, The ps output is after the server start, I don't know why I can't see any process after start the server. And of course I use root to initial db, 'cause we have to run this command in CentOS which you need the privilege of root. service postgresql start Regards, Jason 20

Re: [GENERAL] logger table

2012-12-25 Thread Jason Dusek
imary key? What is the "cycle number"? For what it is worth, I put all my syslog in PG and have so far been fine without primary keys. (I keep only an hour there at a time, though, and it's only a few hundred megs.) In the past, I have had trouble maintaining a high TPS whi

[GENERAL] Workqueue performance

2010-05-11 Thread Jason Armstrong
h data to process by a view which shows just the entries which are in the workqueue table. But then I will have to deal with cleaning all these entries up at some point, which could get complicated in itself. Thanks for any ideas. -- Jason Armstrong -- Sent via pgsql-general mai

Re: [GENERAL] Workqueue performance

2010-05-18 Thread Jason Armstrong
erforming. I decided to do this in application code instead, via IPC. -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] CFP for Surge Scalability Conference 2010

2010-06-14 Thread Jason Dixon
ou've been to Velocity, or wanted to but couldn't afford it, then Surge is just what you've been waiting for. For more information, including CFP, sponsorship of the event, or participating as an exhibitor, please contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Comp

[GENERAL] CFP for Surge Scalability Conference 2010

2010-07-02 Thread Jason Dixon
icipating as an exhibitor, please visit the Surge website or contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] Last day to submit your Surge 2010 CFP!

2010-07-09 Thread Jason Dixon
your business sponsor/exhibit at Surge 2010, please contact us at su...@omniti.com. Thanks! -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Register now for Surge 2010

2010-08-02 Thread Jason Dixon
your seat to this year's event! http://omniti.com/surge/2010/register Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

[GENERAL] Nodes and trees...

2010-08-03 Thread Jason Schauberger
is not, at least it must be easily portable across the most popular SQL databases. I also explicitly don't want to create an extra tree ID or something like that, because it only mitigates the problem of anomalies, but does not solve it. Thanks in advance, Jason. -- Sent via pgsql-general mail

  1   2   3   4   >