Re: [GENERAL] Using timestamp(tz) in C functions

On Fri, Jul 29, 2016 at 11:49 AM, Vitaly Burovoy <vitaly.buro...@gmail.com> wrote: > On 7/29/16, Keith Fiske <ke...@omniti.com> wrote: > > On Fri, Jul 29, 2016 at 12:53 AM, Vitaly Burovoy < > vitaly.buro...@gmail.com> > > wrote: > > > >&g

Re: [GENERAL] Using timestamp(tz) in C functions

On Fri, Jul 29, 2016 at 12:53 AM, Vitaly Burovoy <vitaly.buro...@gmail.com> wrote: > On 7/28/16, Keith Fiske <ke...@omniti.com> wrote: > > Working on trying to get a C version of the maintenance function for my > > pg_partman extension working so I can hope

Re: [GENERAL] Using timestamp(tz) in C functions

On Thu, Jul 28, 2016 at 5:28 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 07/28/2016 02:15 PM, Keith Fiske wrote: > >> Working on trying to get a C version of the maintenance function for my >> pg_partman extension working so I can hopefully make it more f

[GENERAL] Using timestamp(tz) in C functions

oing about this the right manner for the way I intend to use the timestamp values. Still fairly new to C and getting use to postgres internals. Any help, or even an example of using timstamp data pulled from a table in C with SPI, would be great. Thanks! -- Keith Fiske Database Administrator OmniT

Re: [GENERAL] handling time series data

d <brent.w...@niwa.co.nz> wrote: > Hi Keith, > > This documents a time series database we manage with Postgis, from a > research vessel. We use partitions & clustered indexes, as well as a > "minute identifier" (of sorts) to allow various intervals to be rapidly >

[GENERAL] handling time series data

By reading this, http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com, I was wondering if anything has changed on the postgresql front. I have a large timeseries (2TB worth of uncompressed data). I will be doing some queries which change at times.

Re: [GENERAL] Postgresql 9.4 and ZFS?

filesystem. Just make a 9.5 directory in the same spot when the time comes around. With ZFS snapshots available, there's really no reason not to use the --link option to greatly speed up upgrades. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wed, Sep 30, 2015 at 4:58 PM, Benjamin Smith <b...@chico.com> wrote: > On Wednesday, September 30, 2015 03:49:44 PM Keith Fiske wrote: > > We've run postgres on ZFS for years with great success (first on > > OpenSolaris, now on OmniOS, and I personally run it on FreeBSD).

Re: [GENERAL] WAL Shipping and streaming replication

l.org/mailpref/pgsql-general > If you've encountered bugs with OmniPITR, please feel free to open an issue on Github. If you look at the issue and commit history you can see that we do indeed fix reported issues or respond to help people with problems they are having. https://github.com/omniti-labs/omnipitr -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] Alter column from text[] to uuid[]

On Thu, Jun 11, 2015 at 12:57 PM Tom Lane t...@sss.pgh.pa.us wrote: alter table t alter u type uuid[] using u::uuid[]; The original command worked without a USING because anything-to-text is considered an allowable assignment coercion; but the other way around requires an explicit cast. Got

[GENERAL] Alter column from text[] to uuid[]

I have a table: kr=# create table t (u uuid[]); CREATE TABLE Time: 3.742 ms kr=# insert into t values ('{0289b709-3cd7-431c-bcbe-f942eb31b4c5,86cc14d6-7293-488e-a85f-384ae6773d28}'); INSERT 0 1 Time: 1.735 ms I recently did the following: kr=# alter table t alter u type text[]; ALTER TABLE

Re: [GENERAL] Background worker assistance review

http://www.keithf4.com On Tue, Apr 21, 2015 at 5:47 PM, Keith Fiske ke...@omniti.com wrote: http://www.keithf4.com On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske ke...@omniti.com wrote: On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer cr...@2ndquadrant.com wrote: On 9 April 2015 at 05

Re: [GENERAL] Background worker assistance review

http://www.keithf4.com On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske ke...@omniti.com wrote: On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer cr...@2ndquadrant.com wrote: On 9 April 2015 at 05:35, Keith Fiske ke...@omniti.com wrote: I'm working on a background worker (BGW) for my pg_partman

[GENERAL] Background worker assistance review

appreciate it. All I really have it doing now is calling the run_maintenance() function at a defined interval and don't need it doing more than that yet. https://gist.github.com/keithf4/0047eae0b3a22829d527 -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] 9.3.5 failing to compile with dtrace on FreeBSD 10.1

of the other steps besides the kernel loading are needed for compilation and installation, but could be handy. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com On Mon, Dec 22, 2014 at 2:22 PM, Lacey Powers lacey.lea...@gmail.com wrote: Hello Luca, I had

[GENERAL] Updating timezone setting

then just leaving the columns as timestamp without time zone? I know that's not ideal, but that would be a big project to try and convert every single one of those columns. Thanks, -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

[GENERAL] Bloat check query

accurate able to provide some assistance? -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] Bloat check query

On Tue, Aug 26, 2014 at 5:44 PM, Keith Fiske ke...@omniti.com wrote: So I recently wrote this script to help us in monitoring for table/index bloat https://github.com/keithf4/pg_bloat_check I based my query off of the one contained in check_postgres, since I thought it seemed fairly

Re: [GENERAL] HOT standby with ONLY WAL shipping?

the parameter hot_standby on the slave and ensuring the master has a minimum wal_level of hot_standby as well. So both streaming and wal replay slaves can be hot standbys. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [HACKERS] [GENERAL] Question about partial functional indexes and the query planner

on partial_functional_idx (cost=0.00..81.42 rows=5000 width=0) (actual time=39.657..39.657 rows=50 loops=1) Planning time: 0.127 ms Execution time: 2483.979 ms (7 rows) -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] How can I tell if pg_restore is running?

-triggers ? Yes, this extension needs to work with everyone's normal restore process. Otherwise I would have to ask everyone who used my extension to modify their pg_restore command. This also means that I can't rely on a wrapper to pg_restore, as Keith suggested earlier. Moshe Jacobson

Re: [GENERAL] How can I tell if pg_restore is running?

/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS You'd probably have to wrap your pg_dump/restore in some sort of script that can call the advisory locks, but I don't see why it wouldn't work. Then you'd have your triggers check if the advisory lock is held and skip whatever they do if so. -- Keith

[GENERAL] Trigger function permissions

no explicit permissions to the trigger function and inserts still work even after revoking PUBLIC. https://gist.github.com/keithf4/83c5c6516e2726609675 -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] Merge a sharded master into a single read-only slave

not having stale data for too long and keeping up with writes. Sébastien If you have any questions while evaluating it, feel free to ask or post any issues to github. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

Re: [GENERAL] Merge a sharded master into a single read-only slave

of the 512 tables has to be set up individually. But once it was set up it worked surprisingly well. And it's honestly a use case I had never foreseen for the extension. Not sure if this would work in your case, but maybe it can at least give you an idea of what can be done. -- Keith Fiske Database

Re: [GENERAL] what should be the best autovacuum configuration for daily partition table

analyze verbose ' || oid::regclass || ';' from pg_class where relkind in ('r', 't') and age(relfrozenxid) 1 order by age(relfrozenxid) desc limit 25 psql -d $1 -t -a -f /tmp/manual_vacuum_$1.sql $HOME/manual_vacuum_$1.log 21 Keith http://www.keithf4.com

[GENERAL] Postgres usage of session identifiers for security

session identifier? My security team is asking and I can't find any documentation on this. Thanks, Keith

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

Just wanted to say thanks again for the help to those that responded. For anyone curious, this helped me get a more advanced constraint exclusion feature finished for the partition manager I've been working on http://www.keithf4.com/managing-constraint-exclusion-in-table-partitioning/ -- Keith

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

David, That seems to have fixed it! I was going down a path of grabbing the column's type from pg_attribute and trying to work from there, but was still having some of the same issues. Thanks everyone else that replied as well! -- Keith Fiske Database Administrator OmniTI Computer Consulting

Re: [GENERAL] replicate per tablespace

://slony.info/ https://github.com/omniti-labs/mimeo Hope that helps to answer your questions -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com

[GENERAL] Planning error in dynamic string creation in plpgsql

IF EXISTS test_temp; END $$; keith=# select testing_record(); NOTICE: v_record: (1,2) NOTICE: v_sql: col1 min: '1', col1 max: '2' NOTICE: v_record: (2014-01-05 21:24:21.039656,2014-01-06 21:24:21.039656) NOTICE: v_sql: col3 min: '2014-01-05 21:24:21.039656', col3 max: '2014-01-06 21:24:21.039656

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

Sorry, forgot to include that I've tested this on PostgreSQL versions 9.2.6 and 9.3.2 and same thing happens on both. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com On Sun, Jan 5, 2014 at 9:31 PM, Keith Fiske ke...@omniti.com wrote: Running

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

with no issue. Any chance you can explain what's going on here? Never would've thought to put the cast there to fix the problem. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com On Sun, Jan 5, 2014 at 11:06 PM, Adrian Klaver adrian.kla...@gmail.comwrote

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

Actually, that doesn't work right. Gives weird results when the column is an integer Example: keith=# select min(col1), max(col1) from partman_test.time_static_table_p2014_01_01; min | max -+- 86 | 100 (1 row) keith=# select min(col1::text), max(col1::text) from

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

I can't remove the quote_literal() because the value could potentially be a string, time, or number. Without the loop, quote_literal() handles the variable being any one of those types without any issues and quotes (or doesn't) as needed. -- Keith Fiske Database Administrator OmniTI Computer

Re: [GENERAL] Planning error in dynamic string creation in plpgsql

That is not an option either. This is for a publicly released extension and I'm really not going to go requiring another scripting language be installed, especially an untrusted one. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com On Sun, Jan 5

Re: [GENERAL] Foreign Key violated

signs of corruption or other FKs being violated, we asked the for more information about what had been done recently and they fessed up. So, relief on one hand that there was no data corruption. But a bit troubling that the user did that :p -- Keith Fiske Database Administrator OmniTI Computer

[GENERAL] Foreign Key violated

)=(1008122437, r) is not present in table rmas. prod=# rollback; ROLLBACK This is running 9.2.4 on CentOS. If anyone can suggest how I can look into this deeper and find what the problem may be, I'd appreciate it. I'm here at PGCon if anyone is available to help IRL as well -- Keith Fiske Database

[GENERAL] 9.1.3 AIX build issue

gcc -maix64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv pg_ctl.o -L../../../src/port -lpgport -L../../../src/interfaces/libpq -lpq -L../../../src/port -Wl,-bbigtoc

[GENERAL] Can't reset password

Hello, I deleted my Postgresql and try to reinstall it. I try to reset the password by typing in net user postgres *. However, the new password doesn't work when the installer prompt me to input the password. Could you please help me? Thanks, Keith -- Sent via pgsql-general mailing list

[GENERAL] Issue with extension updates to pg_extension table

seemed a rather odd behavior so I thought I'd bring it up in case it's something that can be easily fixed. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Extension table data

documented now. I think its time to recognize the extension system is more widely usable than it was originally intended. And that's a good thing! We just need to try to find ways to make the existing tools work in a more predictable manner now. -- Keith Fiske Database Administrator OmniTI Computer

Re: [GENERAL] Extension table data

to pg_dump is needed, and have the schema-only or data-only options be honored in that case as well. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 On Fri, Jun 8, 2012 at 11:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: Keith Fiske ke...@omniti.com writes

Re: [GENERAL] Extension table data

is to explicitly name all schemas but the one your extension is in, which I think is another bug you had actually fixed for 9.1.3 where extension data was always being dumped. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 On Sat, Jun 9, 2012 at 2:56 AM, Keith Fiske

[GENERAL] Extension table data

? Extension I'm working on: https://github.com/omniti-labs/pg_jobmon Anyone else having this issue or am I doing something wrong? -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] ALTER DEFAULT PRIVILEGES target_role doesn't work with group roles

unreasonable. -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. 443.325.1357 x251 -- 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 update stavaluesN columns in pg_statistics (type anyarry)

Hi, I need to spoof statistics, and so need to update the stavaluesN columns in pg_statistics, which are of type anyarray. Can this be done using an UPDATE statement ? I have tried using array[...] and '{...}' syntax with no luck. Any other ideas as to how to achieve this ? Thanks, Keith.

Re: [GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

2009/5/22 Tom Lane t...@sss.pgh.pa.us Keith Hayden keith.c.hay...@googlemail.com writes: I need to spoof statistics, and so need to update the stavaluesN columns in pg_statistics, which are of type anyarray. Can this be done using an UPDATE statement ? I have tried using array

Re: [GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

2009/5/22 Keith Hayden keith.c.hay...@googlemail.com 2009/5/22 Tom Lane t...@sss.pgh.pa.us Keith Hayden keith.c.hay...@googlemail.com writes: I need to spoof statistics, and so need to update the stavaluesN columns in pg_statistics, which are of type anyarray. Can this be done using

[GENERAL] running postgresql on a private machine accessing it from public web pages

have to use one database types, i.e., postgresql. Thanx, keith -- Nonviolence is not a cover for cowardice, but it is the supreme virtue of the brave. Mohandas Karamchand Gandhi === Keith D. Evans Joint Center for Earth Systems Technology

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

? thanx keith Joshua D. Drake wrote: So, the question is, can someone go through these (public) web pages and access the postgresql database if the postgresql server is running on the private machine? We have other data in the postgresql and would like to only have to use one database types

Re: [GENERAL] running postgresql on a private machine accessing it from public web pages

users accessing through the internet on the public pages to access the data? thanx, keith Raymond O'Donnell wrote: On 21/05/2009 18:49, Keith D. Evans wrote: The database is on a public machine (Linux), but the postgresql postmaster runs on a private machine (Solaris 10

[GENERAL] Suspected bug: outer WHERE reordered before inner WHERE - input syntax ERROR

to reorder the clause of the subselect before the outer select. I'm running the Ubuntu postgresql package version 8.3.3-0ubuntu0.8.04. I'm also interested in responses of the form why not just do X?. -- John Keith Hohm [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Suspected bug: outer WHERE reordered before inner WHERE - input syntax ERROR

. -- John Keith Hohm [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PL/PGSql function within a view definition

Due to limitations (perceived or real) within my client application I am trying to return a complex dataset which I am assembling using an expensive PL/PGSql function which I would like to wrap in a writeable view. I have written the function as both a row-level function which returns a

[GENERAL] Hijack!

by subject. If this is such a problem, probably it should be laid out on the list information page, otherwise how is anyone to know? Putting this information here would be a good thing: http://www.postgresql.org/community/lists/ Keith (not scolding, but Hijack is an accusative term)

Re: [GENERAL] Hijack!

:[EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 6:58 AM To: Keith Turner Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Hijack! Keith Turner wrote: Someone scolding wrote: Please don't hijack other threads, the original thread was 'TIMESTAMP difference'. I think it was probably

Re: [GENERAL] Restore problem

On 12/10/07, Keith Turner [EMAIL PROTECTED] wrote: We are running 8.1 on Windows 2003 server and have had a server crash over the weekend. A virus is suspected - we maintain an app server on someone else's network, though we do have anti-virus running, the symptoms were worrying - so we had

[GENERAL] Restore problem

possible? Thanks, Keith ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] Bitemporal sequenced unique constraint (function/trigger)

in Customers during the validity of Prop_Owner?? The data I used is as follows: Customers: customer_no |customer_name | vt_begin | vt_end | tt_start | tt_stop -+++++ 1 | keith | 2006-01-01

Re: [GENERAL] Compiling libpqddll.lib win32 mingw msys

using nmake /f win32.mak DEBUG=1 from the src folder for postgresql-8.1.3. The binaries don't compile but the libraries and dlls do. -- Keith Hutchison http://balance-infosystems.com http://realopen.org ---(end of broadcast)--- TIP 1: if posting

[GENERAL] Compiling libpqddll.lib win32 mingw msys

What parameters have to be passed to configure or make to build the import library files like libpqddll.lib on win32 using msys and mingw? Thank in advance -- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison

[GENERAL] pg_config --includedir is null

-- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison Output of pg_config $ /c/usr/src/postgresql-8.1.3/src/bin/pg_config/pg_config.exe BINDIR = c:/usr/src/POSTGR~1.3/src/bin/PG_CON~1 DOCDIR = INCLUDEDIR = PKGINCLUDEDIR = INCLUDEDIR-SERVER = LIBDIR

[GENERAL] Java Eclipse

Any views on the best way to access postgresql within java? -- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

Re: [GENERAL] clustering by partial indexes

Quoting Tom Lane [EMAIL PROTECTED]: Keith C. Perry [EMAIL PROTECTED] writes: This might have been discussed before but I wanted to know if clustering tables by partial indexes will be availble in a later release of pgSQL? What in the world would it mean to do that? I'm not sure I

[GENERAL] clustering by partial indexes

as: iprism=# \d hrs_idx Index public.hrs_idx Column | Type +-- stamp | timestamp with time zone btree, for table public.report, predicate (thehour(stamp) = 0::double precision AND thehour(stamp) = 23::double precision) -- Keith C. Perry, MS E.E

Re: [GENERAL] Why database is corrupted after re-booting

---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Keith C. Perry, MS E.E. Director

Re: [GENERAL] Why database is corrupted after re-booting

? http://www.postgresql.org/docs/faq -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast

Re: [GENERAL] [INTERFACES] calculated identity field in views, again...

your desire to choose an index scan if your joining column's datatypes do not match Another option is to toss the MS Access altogether and program the front end entirely in VB. That is what we did. -- Kind Regards, Keith Zlatko Matic wrote: You mean VB.NET ? Actually we wrote

Re: [GENERAL] [INTERFACES] calculated identity field in views, again...

to choose an index scan if your joining column's datatypes do not match Another option is to toss the MS Access altogether and program the front end entirely in VB. That is what we did. -- Kind Regards, Keith ---(end of broadcast)--- TIP 1

Re: [GENERAL] PostgreSQL still for Linux only?

access via a public IP then it would more certainly be behind another firewall that is NAT'ing/Port Forwarding its traffic. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc

Re: [GENERAL] PostgreSQL still for Linux only?

-windows platform to run your production database. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast

[GENERAL] Replication from other SQL Server

Hi, I am new to postgresql! We have a M$SQL server and would like to do a replication from this server to postgresql. Would this be possible? If so, what would be the appropiate method. Any suggestion? Thx! ---(end of broadcast)--- TIP 5: Have

Re: [GENERAL] Lost rows/data corruption?

used? -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 9: the planner

Re: [GENERAL] PostgreSQL users on webhosting

to the mailing list cleanly ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN

Re: [GENERAL] What HW / OS is recommeded

might want to look into are JFS and ReiserFS. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast

[GENERAL] Help with query: indexes on timestamps

. Is there a better way? Thanks to all in advance. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast

Re: [GENERAL] Help with query: indexes on timestamps

Quoting Richard Huxton [EMAIL PROTECTED]: Keith C. Perry wrote: I have a table with with 1 million records in it. Here is the definition CREATE TABLE report ( match int4, action varchar(16), stamp timestamptz, account varchar(32), ipaddress inet, profile

Re: [GENERAL] upgrade postgres 7.1 to 7.4.2

parameter). If you are not on a network, you could install 7.4 version in a different directory and configure to run on a different port. You still dump via IP this way. You can run both systems head to head that way and see how things went. Good luck- -- Keith C. Perry, MS E.E. Director of Networks

Re: [GENERAL] Postgres clustering?

Thanks Andrew, I will do some digging on the Postgres-R front to see what their focus is. Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: Thursday, February 26, 2004 4:36 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL

Re: [GENERAL] How should I get started?

our the http://techdocs.postgresql.org site to read about some more hands on and in depth information. There is also http://gborg.postgresql.org where you can download some of the other software tools, interfaces, etc that you may need develope and deploy your applications. -- Keith C. Perry, MS

Re: [GENERAL] Postgress and MYSQL

shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com

Re: [GENERAL] Best practice? Web application: single PostgreSQL

John Sidney-Woollett wrote: Keith G. Murphy said: 2) have the web server connecting to the database actually using the user's account (possibly using LDAP authentication against PostgreSQL), and controlling access to different database entities through GRANT, etc. My experience with java web

Re: [GENERAL] Best practice? Web application: single PostgreSQL

John Sidney-Woollett wrote: Keith G. Murphy said: That sounds like an excellent compromise. How do you typically handle the mechanics of authentication from web server to PostgreSQL on the connect, using this scheme? Sorry but I can't help you out here, I'm too much of a newbie with Postgres

Re: [GENERAL] Best practice? Web application: single PostgreSQL

Tom Lane wrote: Keith G. Murphy [EMAIL PROTECTED] writes: Hmmm, mightn't it be kind of nice if there were PAM or krb5 maps in addition to ident maps? ISTM the whole point of PAM is that you plug in your desired security policy outside of the application. You shouldn't be asking for more

Re: [GENERAL] Best practice? Web application: single PostgreSQL

scott.marlowe wrote: On Tue, 13 Jan 2004, Keith G. Murphy wrote: I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are logging onto the web server using

Re: [GENERAL] TPC-C and Postgres

Mysql 4.0.15) Once again proof is in the pudding! regards Mark ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http

Re: [GENERAL] 'like' refuses to use an index???

for somebody, whose last name ends with erry (as opposed to begins with Perr). Dima Keith C. Perry wrote: I wanted to know this too because I notice that using like with wildcards appears to be similar to a regular expression in that the index is not used. This is what I have

Re: [GENERAL] 'like' refuses to use an index???

) -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 5: Have you checked our

Re: [GENERAL] 'like' refuses to use an index???

://www.postgresql.org/docs/faqs/FAQ.html -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 5

Re: [GENERAL] Is my MySQL Gaining ?

a wish list somewhere. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 3

Re: [GENERAL] Is my MySQL Gaining ?

-- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [GENERAL] Is my MySQL Gaining ?

---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http

Re: [GENERAL] Is my MySQL Gaining ?

. Not very scientific I know :) Seriously though, when people indicate PG is hard, I hear, if it was easy everone would be doing it. -$0.02 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Keith C. Perry, MS E.E. Director

Re: [GENERAL] Is my MySQL Gaining ?

are NOT using Windows somewhere, and an increasing number of organizations are starting understand OSS solutions. So both world are merging so it not about avoiding and one thing. Its about picking an choosing your battles. Keith C. Perry wrote: The way I look at it is that I probably don't

Re: [GENERAL] Is my MySQL Gaining ?

prohibitive. Then again, that might simply be the way they want it. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Keith C. Perry, MS E.E

Re: [GENERAL] Duplication to External Server

it. If you are using 7.4 you could even use pg_dump with ssh in a similar manner. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com

Re: [GENERAL] [NOVICE] PostgreSQL Training

Bruce's said his materials are on his web site so perhaps we should start there with the intention of repackaging that information for community distribution. -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email

Re: [GENERAL] tablespaces in 7.5?

-tablespaces.htm http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch8.htm -Original Message- From: John Sidney-Woollett [mailto:[EMAIL PROTECTED] Sent: Sat 12/13/2003 4:38 AM To: Keith C. Perry Cc: Bruce Momjian; Brian Maguire; [EMAIL

Re: [GENERAL] Perl with-perl configuration option

is Pg.pm (http://gborg.postgresql.org/project/pgperl/projdisplay.php). -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end

  1   2   >