On 12/2/2016 10:37 PM, James Zhou wrote:
I am new to PostgreSQL and am leaning it. I installed PostgreSQL on a
Windows 7 laptop and would like to play with pgbench to generate a
sample database and a bit load.
As I read, pgbench should come with the server download. But after I
install it, I
Hi,
I am new to PostgreSQL and am leaning it. I installed PostgreSQL on a
Windows 7 laptop and would like to play with pgbench to generate a sample
database and a bit load.
As I read, pgbench should come with the server download. But after I
install it, I could find pgbench:
[image: Inline image
On Sat, Dec 3, 2016 at 2:52 PM, Maeldron T. wrote:
> Upgrading FreeBSD from 10 to 11 might break your database. It probably won’t
> be corrupted but it will be useless until you dump-import it, and you might
> need to do manual fixing.
Sorry to hear about your arm and your database.
The collatio
I forgot to add that when I turned off index scan, select lower() still
didn’t find some existing rows.
On Sat, Dec 3, 2016 at 2:52 AM, Maeldron T. wrote:
> Hello,
>
> I’ll be as short as I can as I have broken my arm and I’m not supposed to
> type. This isn’t a joke.
>
> However, I learned the
Hello,
I’ll be as short as I can as I have broken my arm and I’m not supposed to
type. This isn’t a joke.
However, I learned the following the hard way and I want to save you from
the same.
Upgrading FreeBSD from 10 to 11 might break your database. It probably
won’t be corrupted but it will be u
Greetings,
I’d like to announce the availability of a PostgreSQL extension that I’ve sat
on for a year – it’s time to share! It provides undo/redo functionality useful
to application developers that want to persist application objects in a
PostgreSQL database. It does some gymnastics using
On 12/02/2016 09:40 AM, Tom DalPozzo wrote:
Hi,
I've two tables, t1 and t2, both with one bigint id indexed field and
one 256 char data field; t1 has always got 1 row, while t2 is
increasing as explained in the following.
My pqlib client countinously updates one row in t1 (every time
target
On 12/2/2016 12:19 AM, Job wrote:
We need to archive this data to generate report and analysis views.
on top of what Stephen said, I'd do as much preprocessing, and
preaggregation as possible to simplify and speed up those
report/analysis views for instance, storing min/max/mean rollups
Hi,
i found out where the config files were. I connected to the postgres
database, executed the "SHOW data_directory" command and edited the correct
"pg_hba.conf". After that, the "createdb" command worked properly.
Thanks for the attention.
2016-12-02 15:29 GMT-03:00 Fabricio Pedroso Jorge :
On Thu, Dec 1, 2016 at 6:17 PM, Michael Paquier
wrote:
> On Thu, Dec 01, 2016 at 05:48:51PM +0200, Achilleas Mantzios wrote:
> >
> > Performance is the reason. You would benefit from moving pg_xlog to a
> > different controller with its own write cache or to a different SSD with
> a
> > write cac
Hi,
thanks for the attention and help.
Actually, my installation didn't create the *".conf"* files. What i have
are the *".conf.sample"*, created at *"/usr/pgsql-9.5/share"* directory, so
i created a copy of the "postgresql.conf" and "pg_hba.conf" and edited as
follows:
*[root@vm-ora12
On 12/02/2016 09:58 AM, Fabricio Pedroso Jorge wrote:
Hi all,
/[root@vm-ora12 ~]# service postgresql-9.5 status
postgresql-9.5 (pid 18507) is running.../
Why am i getting the above error while trying to create a new database?
See here:
http://stackoverflow.com/questions/2942485/psql-fata
Hi all,
PostgreSQL version...: 9.5.5
OS...: Oracle Linux 6.5 64 bits
I am quite new in the PostgreSQL world and i'm trying to create a new db
with the following sintax, using the "postgres" OS user:
[postgres@vm-ora12 ~]$ createdb -h localhost -p 5432 -U postgre
Hi,
I've two tables, t1 and t2, both with one bigint id indexed field and one
256 char data field; t1 has always got 1 row, while t2 is increasing as
explained in the following.
My pqlib client countinously updates one row in t1 (every time targeting a
different row) and inserts a new row in
På fredag 02. desember 2016 kl. 16:33:12, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>:
cen writes:
> Something funny going on with my full text search.. and I have no idea what.
The way to debug this sort of thing is generally to look at what tsquery
you're actually getting. I get
regression
Thanks, that makes sense. I think I'll go with the cast approach, I
don't really need stemming anywhere.
Tom Lane je 02. 12. 2016 ob 16:33 napisal:
cen writes:
Something funny going on with my full text search.. and I have no idea what.
The way to debug this sort of thing is generally to lo
Understood, and backwards compatibility also of course. Thank you
On Fri, Dec 2, 2016 at 7:20 PM, Tom Lane wrote:
> otar shavadze writes:
> > SELECT ARRAY_LENGTH('{}'::INT[], 1)
> > This returns NULL, not so "dangerous" either way, not would be more
> > logically, if array length function wi
cen writes:
> Something funny going on with my full text search.. and I have no idea what.
The way to debug this sort of thing is generally to look at what tsquery
you're actually getting. I get
regression=# select to_tsquery(unaccent('a:*'));
NOTICE: text-search query contains only stop word
I found the following SQL in stackoverflow:
SELECT
pg_last_xlog_receive_location() receive,
pg_last_xlog_replay_location() replay,
(
extract(epoch FROM now()) -
extract(epoch FROM pg_last_xact_replay_timestamp())
)::int lag
I get different result in primary and slave. On primary the
Something funny going on with my full text search.. and I have no idea what.
I have a receiver called "Ana", this is her tsv column:
'3865100':4 'acevent...@mailinator.com':3B 'ana':1A 'novak':2A
This queries do not find her:
SELECT * FROM receivers r WHERE r.tsv @@ to_tsquery(unaccent('a:*'
otar shavadze writes:
> SELECT ARRAY_LENGTH('{}'::INT[], 1)
> This returns NULL, not so "dangerous" either way, not would be more
> logically, if array length function will return 0 from empty array,
> instead of NULL ?
Well, the issue is that you're asking about dimension 1 of a
zero-dimension
Job writes:
> Tonight this problem happened again:
> CachedPlan: 1024 total in 1 blocks; 640 free (0 chunks); 384 used
> CachedPlanSource: 1024 total in 1 blocks; 336 free (0 chunks); 688 used
> SPI Plan: 1024 total in 1 blocks; 912 free (0 chunks); 112 used
> CachedPlan: 1024 total in 1 blocks;
On 12/02/2016 04:23 AM, Alexander Farber wrote:
Thank you, Rob -
On Fri, Dec 2, 2016 at 11:12 AM, Rob Sargent mailto:robjsarg...@gmail.com>> wrote:
> On Dec 2, 2016, at 2:52 AM, Alexander Farber
mailto:alexander.far...@gmail.com>> wrote:
>
> CREATE OR REPLACE FUNCTION words_unb
Hi!
I have pgBadger report with strange data about prepared queries I cannot
interpret by myself. If anybody could help me with interpretation, would be
greatly appreciated.
In first half of the day pgBadger shows there is no prepare statements and
all queries are binded - how is that possible if a
SELECT ARRAY_LENGTH('{}'::INT[], 1)
This returns NULL, not so "dangerous" either way, not would be more
logically, if array length function will return 0 from empty array,
instead of NULL ?
This is just IMHO.
Job,
* Job (j...@colliniconsulting.it) wrote:
> we are planning to store historically data into a Postgresql 9.6 table.
The question is less about what you're storing in PG and more about what
you're going to be doing with that data.
> We see on Postgresql limit that it could handle "big data".
Thank you, Rob -
On Fri, Dec 2, 2016 at 11:12 AM, Rob Sargent wrote:
>
> > On Dec 2, 2016, at 2:52 AM, Alexander Farber
> wrote:
> >
> > CREATE OR REPLACE FUNCTION words_unban_user(
> > in_uid integer)
> > RETURNS integer AS
> > $func$
> > UPDATE words_users SET
> >
> And finally here is the failing usage of the function :
>
> words=> SELECT uid FROM words_unban_user(1);
> ERROR: column "uid" does not exist
> LINE 1: SELECT uid FROM words_unban_user(1);
> ^
>
>
Shouldn't you be doing:-
SELECT words_unban_user(1);
--
Sent via pgsql-ge
Hello,
why does this fail in PostgreSQL 9.5 please?
Here is my custom SQL function :
CREATE OR REPLACE FUNCTION words_unban_user(
in_uid integer)
RETURNS integer AS
$func$
UPDATE words_users SET
banned_until = null,
banned_reason = null
WHERE uid =
2016-12-02 17:10 GMT+13:00 Michael Paquier
mailto:michael.paqu...@gmail.com>>:
On Fri, Dec 2, 2016 at 1:04 PM, Melvin Davidson
mailto:melvin6...@gmail.com>> wrote:
> Well, while the location of pg_xlog is not currently configurable, on Linux
> system the way to do it is to:
> 1. stop PostgreS
Hello,
we are planning to store historically data into a Postgresql 9.6 table.
We see on Postgresql limit that it could handle "big data".
In fact, limit for a single table is 32 Tb.
We need to archive this data to generate report and analysis views.
Anyone has experienced Postgresql 9.6 with D
31 matches
Mail list logo
