FAQ

Search Discussions

159 discussions - 904 posts

  • I have seen a lot of slow update questions asked both here and on stack overflow but they usually involve large tables. In my case the dataset is kind of small. I have an app in which I import data ...
    Tim UckunTim Uckun
    Jan 21, 2013 at 8:04 am
    Jan 27, 2013 at 10:28 am
  • Hey guys, I'm not sure the last time I saw this discussion, but I was somewhat curious: what would be your ideal Linux distribution for a nice solid PostgreSQL installation? We've kinda bounced back ...
    Shaun ThomasShaun Thomas
    Jan 13, 2013 at 6:27 pm
    Jan 17, 2013 at 6:14 pm
  • What is the behavior if a column data type is timestamptz but there is only the date portion available? There must be a default time; can that be defined? Rich
    Rich ShepardRich Shepard
    Jan 21, 2013 at 3:26 pm
    Jan 27, 2013 at 11:28 am
  • Hello, for a PostgreSQL 8.4.13 database + pgbouncer on a 32 GB RAM machine with CentOS 6.3 / 64 bit I use the following settings: max_connections = 100 shared_buffers = 4096MB work_mem = 32MB ...
    Alexander FarberAlexander Farber
    Jan 26, 2013 at 9:05 pm
    Jan 31, 2013 at 9:01 am
  • Hello, Greetings ! I am new to postgres and recently got migrated from oracle. I am using postgresql 9.2 version. I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with 1 lakh ...
    Bhanu udayaBhanu udaya
    Jan 21, 2013 at 4:10 am
    Mar 1, 2013 at 8:03 am
  • Problem: Some users (scripts actually) try to connect to a DB who's name is derived from environmental variables. The DB doesn't exist (yet), and I want them to connect to a different DB for the time ...
    Gauthier, DaveGauthier, Dave
    Jan 23, 2013 at 8:48 pm
    Jan 26, 2013 at 11:11 pm
  • Hi list, This may be really simple - I usually do it using a procedural language such as php or a bash script. Say I have a table that has 2 columns like create table "foo" ( id integer not null, ...
    Steve ClarkSteve Clark
    Jan 24, 2013 at 4:47 pm
    Jan 27, 2013 at 8:07 am
  • The subject has been discussed on this mailing list before, recently. To be able to switch from SQL Server to Postgresql, for me this is essential. Therefore the question: are there plans to create a ...
    Marcel van PinxterenMarcel van Pinxteren
    Jan 16, 2013 at 6:50 pm
    Jan 21, 2013 at 10:47 pm
  • Hello, I have a pretty standard query with two tables: SELECT table_a.id FROM table_a a, table_b b WHERE ... AND ... AND b.value=...; With the last "AND b.value=..." the query is extremely slow (did ...
    T. E. LawrenceT. E. Lawrence
    Jan 12, 2013 at 1:47 am
    Jan 18, 2013 at 4:29 pm
  • I have a column of type TIMESTAMP, I'd like to query all records from 2011. If it were text I could use a partial such as: WHERE text ~ '2011' There must be a simple way to pull the year part out of ...
    Kirk WythersKirk Wythers
    Jan 8, 2013 at 10:20 pm
    Jan 10, 2013 at 11:12 am
  • Hi, I am trying to match items from 2 tables based on a common string. One is a big table which has one column with entries like XY123, ABC44, etc The table has an index on that column. The second ...
    WolfgangWolfgang
    Jan 30, 2013 at 11:09 am
    Feb 3, 2013 at 12:24 pm
  • I have a lot of VALUES I want to INSERT. But only a subset of them - only those that meet a JOIN criteria involving another table. I could INSERT them into a temp table, and then do a SELECT INTO ...
    Robert JamesRobert James
    Jan 14, 2013 at 2:00 am
    Jan 15, 2013 at 9:20 am
  • my postgresql-9.0-main.log log file is 0 bytes. Postgres user has perms to write to it. And and postgresql.conf file shows to log, but it's not. Not sure why. I have the defaults set in except for ...
    Anson AbrahamAnson Abraham
    Jan 24, 2013 at 5:30 pm
    Jan 28, 2013 at 7:30 pm
  • My database crashed a couple of days ago during an upgrade several seconds after committing a large transaction to the database. Eventually we found out that this was due to the disk being full as ...
    Cliff de CarteretCliff de Carteret
    Jan 22, 2013 at 11:13 am
    Jan 23, 2013 at 9:14 am
  • Hi, I have a plpython stored procedure which sometimes fails when I run my applications automated test suite. The procedure is called hundreds of times during the tests but only fails a few times, ...
    Brian SutherlandBrian Sutherland
    Jan 14, 2013 at 4:30 pm
    Jan 17, 2013 at 1:14 pm
  • I have the need to develop an application that will use postgres as the back end, and most of the design has been worked out, but I've one issue left to resolve and want help in this. If this is not ...
    Rich ShepardRich Shepard
    Jan 3, 2013 at 3:38 pm
    Jan 8, 2013 at 3:20 pm
  • Hello all. I have more than 500 users connect to Postgres in windows 2008 R2. I change registry make postgres service support 512 connect. But is there any good way make postgres run as process not ...
    TuanhoanganhTuanhoanganh
    Jan 3, 2013 at 2:40 am
    Jan 8, 2013 at 2:33 am
  • I'd like to understand what I'm missing when I COPY a table to a .csv file but the text is not quoted. Here's an example of a command: copy chemistry to '/home/postgres/emapchem.csv' with (format ...
    Rich ShepardRich Shepard
    Jan 31, 2013 at 4:37 pm
    Feb 5, 2013 at 2:11 pm
  • Hi all, i am not sure whether i have fully understood the implications of archiving wal-files and i have a few questions. We currently keep a rather long backlog of wal-files, since we have a few ...
    Neil WordenNeil Worden
    Jan 30, 2013 at 8:58 am
    Feb 1, 2013 at 10:15 am
  • I'm wondering why "varchar_opts" is not default operator class for all indexed varchar field. Is the impact to heavy? Thanks for the clarification, Edson
    Edson RichterEdson Richter
    Jan 21, 2013 at 12:38 pm
    Jan 22, 2013 at 8:14 pm
  • For a client who needs to learn how to query the db: - No SQL knowledge at all; needs to start from square 1. - Smart, capable person, who will be in this position for a long time, using this db for ...
    Scott RibeScott Ribe
    Jan 23, 2013 at 10:56 pm
    Jan 27, 2013 at 2:30 pm
  • I am looking for advice on a performance problem. I'm pretty sure that the culprit of my slow performance is a view that is several hundred million records in size. Because it is a view, I can only ...
    Kirk WythersKirk Wythers
    Jan 17, 2013 at 5:16 am
    Jan 18, 2013 at 4:37 pm
  • Hi I have a query like this SELECT ST_AsText(way) geom, name AS label FROM osm_point LIMIT 10; When I repeatedly do this, the result set will be always the same. I have observed this only empirically ...
    Stefan KellerStefan Keller
    Jan 8, 2013 at 3:21 pm
    Jan 11, 2013 at 10:22 pm
  • I neglected to dump a single table before adding additional rows to it via psql. Naturally, I messed up the table. I have a full pg_dumpall of all three databases and all their tables in a single ...
    Rich ShepardRich Shepard
    Jan 22, 2013 at 5:57 pm
    Jan 27, 2013 at 2:45 pm
  • Hi Guys, We are having a problem with our infrastructure provider because the network traffic between master and slave server is reaching more than 30k packages per second(SLA says 20k/second). Is ...
    Rodrigo Pereira da SilvaRodrigo Pereira da Silva
    Jan 25, 2013 at 12:57 pm
    Jan 26, 2013 at 9:13 pm
  • Hello, I am trying to use libpq in two threads, the issue is that I am getting access violation after several successful connections. Each thread connects to different db and disconnects immediately ...
    AsiaAsia
    Jan 11, 2013 at 3:31 pm
    Jan 20, 2013 at 5:52 am
  • My Web searching foo fails me, and I don't see the answer in the postgres docs so I hope someone here can point me in the proper direction. There is a table for bacteriological data that contains two ...
    Rich ShepardRich Shepard
    Jan 18, 2013 at 11:31 pm
    Jan 19, 2013 at 5:51 pm
  • I'm wondering if anyone can point me towards a good method for moving mysql data into Postgres? I've done some web searching, and found documentation from various years, but it's not clear what's ...
    Ken TanzerKen Tanzer
    Jan 11, 2013 at 11:55 pm
    Jan 16, 2013 at 1:16 am
  • Hello, from some time I have a very strange problem with my postgresql 9.2.2 64bit. I make a few changes with an plp function: BEGIN UPDATE table SET X = X where id = aid; UPDATE table_2 SET Y=Y ...
    CondorCondor
    Jan 14, 2013 at 8:15 am
    Jan 14, 2013 at 9:54 am
  • I am getting a repeating error and not sure what why. 2013-01-08 06:12:08 MSTERROR: absolute path not allowed 2013-01-08 06:12:08 MSTSTATEMENT: SELECT pg_read_file($1, 0, 1048576) 2013-01-08 06:42:10 ...
    Wolf SchwurackWolf Schwurack
    Jan 8, 2013 at 3:08 pm
    Jan 10, 2013 at 9:33 pm
  • I have a little problem, I let my drive get too full. And then while I was deleting rows to free space, the auto vacuum didn't kick in quite the way I expected, and I ran out of space entirely. So ...
    John AbrahamJohn Abraham
    Jan 3, 2013 at 11:31 pm
    Jan 8, 2013 at 12:56 pm
  • Hi, I have two variables in pl/pgsql function. p_fromdate and p_todate I have another variable which represents intervals like day, month, quarter etc. p_interval as smallint, to hold values like ...
    C kC k
    Jan 28, 2013 at 1:24 pm
    Feb 3, 2013 at 12:14 pm
  • Hi all, I've notice not all my functions are tracked by pg_stat_user_functions view. Interesting thing is similar functions in different db are tracked correctly. query: SELECT p.* FROM pg_proc p ...
    Bartosz DmytrakBartosz Dmytrak
    Jan 18, 2013 at 9:21 am
    Jan 30, 2013 at 8:58 am
  • Do the declare statements and insert all have to be done in one statement execute()? That is, what is the scope of variables I declare? I see a variety of syntax examples, some for older versions? ...
    Bob FutrelleBob Futrelle
    Jan 28, 2013 at 12:11 pm
    Jan 28, 2013 at 10:42 pm
  • Hello! I have convinced a client to use PostgreSQL instead of MySQL (hooray), which means it falls on me to install and configure it. I'm planning on doing this from the command line (I have SSH ...
    Stephen CookStephen Cook
    Jan 28, 2013 at 2:45 pm
    Jan 28, 2013 at 8:34 pm
  • I'd like to better understand TIMESTAMP WITH TIME ZONE. My understanding is that, contrary to what the name sounds like, the time zone is never stored. It simply stores a UTC timestamp, identical to ...
    Robert JamesRobert James
    Jan 18, 2013 at 5:31 pm
    Jan 21, 2013 at 4:43 am
  • Hi, I want to store clickmap points (X, Y and hits value) for website I currently have table like this CREATE TABLE clickmap ( page_id integer, date date, x smallint, y smallint, hits integer ) But ...
    AasatAasat
    Jan 8, 2013 at 10:12 am
    Jan 17, 2013 at 9:36 am
  • I need to cast a double precision into an integer, and I want to check that the value will actually fit (modulo rounding). Coming from a C/Java background, this seems like something that should be ...
    Ian PilcherIan Pilcher
    Jan 26, 2013 at 9:13 pm
    Jan 27, 2013 at 8:58 am
  • Hi, I need to filter xid != 0. I tried this "not(t_xmax = 0)" but I dont sure that this work ok How I do it? Create or replace function obtener_info_reg(tabla varchar, buscareliminado boolean, curs ...
    Alejandro CarrilloAlejandro Carrillo
    Jan 20, 2013 at 1:46 pm
    Jan 21, 2013 at 4:11 pm
  • While researching a problem with a different database system, I came across the following in the SQL standard ISO/IEC 9075-2:2003, Section 8.2 (<comparison predicate ), General Rules: 3) The ...
    Albe LaurenzAlbe Laurenz
    Jan 17, 2013 at 9:26 am
    Jan 21, 2013 at 3:54 pm
  • I'd like to understand better why manually using a temp table can improve performance so much. I had one complicated query that performed well. I replaced a table in it with a reference to a view, ...
    Robert JamesRobert James
    Jan 18, 2013 at 5:29 pm
    Jan 18, 2013 at 10:07 pm
  • Hello, I'm forced to log into a server via SSH and the ubuntu user via ssh keys. The ubuntu Postgres OS user has no password by default. When I log in via ssh, I log in via the ubuntu user, and then ...
    PasilveiraPasilveira
    Jan 12, 2013 at 5:31 am
    Jan 13, 2013 at 5:51 am
  • Can anyone see what I'm misisng? I am trying to run a psql "copy from" command through a bash script to load a buch of cdv files into the same table. I'm getting an error about the file "infile" not ...
    Kirk WythersKirk Wythers
    Jan 11, 2013 at 6:13 pm
    Jan 12, 2013 at 2:38 am
  • Hello, I build a function and added some warnings where the id of the affected rows are inside it; and would be nice to put it into a detail, not in the message, since pgbadger can group it and I can ...
    DANIEL CRISTIAN CRUZDANIEL CRISTIAN CRUZ
    Jan 29, 2013 at 1:04 pm
    Feb 3, 2013 at 12:09 pm
  • As our production system are being upgraded to Windows 7 64-bit we are finding that our Tcl apps which use the PgTcl client libraries are now failing (couldn't load library "libpgtcl.dll": invalid ...
    Carlo StonebanksCarlo Stonebanks
    Jan 30, 2013 at 10:45 pm
    Feb 1, 2013 at 5:19 am
  • Hi all, I have a question about database design best pratice. In my db I have about one hundred tables like this: code description To avoid to have a so great number of similar tables in the db I ...
    Jose SoaresJose Soares
    Jan 28, 2013 at 9:47 am
    Jan 30, 2013 at 5:43 pm
  • Hello, I run a card game written in Perl on a CentOS 6.3 / 64 bit + PostgreSQL 8.4.13 where quite a lot player statistics are written to the d/b (score, game results, moves, etc.) Here a player ...
    Alexander FarberAlexander Farber
    Jan 21, 2013 at 12:57 pm
    Jan 24, 2013 at 2:26 am
  • Hello, I have been fighting a problem with an update rule on a view. I have a view that combines two tables where the 'sub' table (scont) can have several rows per row in the 'top' table (icont). The ...
    Leif JensenLeif Jensen
    Jan 18, 2013 at 2:19 pm
    Jan 22, 2013 at 3:16 pm
  • Is there a recommended, high performance method to check for subdomains? Something like: - www.google.com is subdomain of google.com - ilikegoogle.com is not subdomain of google.com There are many ...
    Robert JamesRobert James
    Jan 16, 2013 at 8:23 pm
    Jan 18, 2013 at 10:00 am
  • Is there any way to determine, by querying pg_index and other pg_* tables, whether an index was created as `USING something`? I've already got a big query joining pg_class, pg_index, etc. to pull out ...
    Paul JungwirthPaul Jungwirth
    Jan 17, 2013 at 6:04 pm
    Jan 17, 2013 at 7:49 pm
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions159
posts904
users218
websitepostgresql.org
irc#postgresql

218 users for January 2013

Adrian Klaver: 67 posts Tom Lane: 49 posts Kevin Grittner: 27 posts Jeff Janes: 23 posts Tim Uckun: 22 posts Rich Shepard: 20 posts Albe Laurenz: 19 posts Steve Crawford: 19 posts Edson Richter: 18 posts Alexander Farber: 16 posts John R Pierce: 15 posts Alban Hertroys: 14 posts Jasen Betts: 14 posts Scott Marlowe: 14 posts Gauthier, Dave: 13 posts Robert James: 13 posts Chris Angelico: 12 posts Craig Ringer: 12 posts Gavan Schneider: 12 posts Pavel Stehule: 12 posts
show more
Archives